1) To find the name of the driver who did not have an accident in 'Delhi', you would first need to identify the drivers who had an accident in 'Delhi'. This can be done by joining the 'Person' and 'Accident' tables on the 'SSN' field and filtering for accidents in 'Delhi'. Then, you would need to select the drivers from the 'Person' table who are not in the list of drivers who had an accident in 'Delhi'.

Here is the SQL query for this:

```sql
SELECT name
FROM Database.Person
WHERE SSN NOT IN (
SELECT SSN
FROM Database.Accident
JOIN Database.Person ON Database.Accident.SSN = Database.Person.SSN
WHERE city = 'Delhi'
)
```

2) To find the cars sold in 2006 and whose owners are from Vadodara, you would need to join the 'Person' and 'Car' tables on the 'SSN' field and filter for cars sold in 2006 and persons from Vadodara.

Here is the SQL query for this:

```sql
SELECT license_no, year, model
FROM Database.Car
JOIN Database.Person ON Database.Car.SSN = Database.Person.SSN
WHERE year = 2006 AND city = 'Vadodara'
```

3) To find out how many different models of car are used by Mr.abc, you would need to join the 'Person' and 'Car' tables on the 'SSN' field and filter for the person named 'Mr.abc'. Then, you would need to count the distinct models of cars.

Here is the SQL query for this:

```sql
SELECT COUNT(DISTINCT model)
FROM Database.Car
JOIN Database.Person ON Database.Car.SSN = Database.Person.SSN
WHERE name = 'Mr.abc'
```

Question

1) To find the name of the driver who did not have an accident in 'Delhi', you would first need to identify the drivers who had an accident in 'Delhi'. This can be done by joining the 'Person' and 'Accident' tables on the 'SSN' field and filtering for accidents in 'Delhi'. Then, you would need to select the drivers from the 'Person' table who are not in the list of drivers who had an accident in 'Delhi'.

Here is the SQL query for this:

```sql
SELECT name 
FROM Database.Person 
WHERE SSN NOT IN (
    SELECT SSN 
    FROM Database.Accident 
    JOIN Database.Person ON Database.Accident.SSN = Database.Person.SSN 
    WHERE city = 'Delhi'
)
```

2) To find the cars sold in 2006 and whose owners are from Vadodara, you would need to join the 'Person' and 'Car' tables on the 'SSN' field and filter for cars sold in 2006 and persons from Vadodara.

Here is the SQL query for this:

```sql
SELECT license_no, year, model 
FROM Database.Car 
JOIN Database.Person ON Database.Car.SSN = Database.Person.SSN 
WHERE year = 2006 AND city = 'Vadodara'
```

3) To find out how many different models of car are used by Mr.abc, you would need to join the 'Person' and 'Car' tables on the 'SSN' field and filter for the person named 'Mr.abc'. Then, you would need to count the distinct models of cars.

Here is the SQL query for this:

```sql
SELECT COUNT(DISTINCT model) 
FROM Database.Car 
JOIN Database.Person ON Database.Car.SSN = Database.Person.SSN 
WHERE name = 'Mr.abc'
```

Knowee AI · Accepted Answer

1) To find the name of the driver who did not have an accident in 'Delhi', you would first need to identify the drivers who had an accident in 'Delhi'. This can be done by joining the 'Person' and 'Accident' tables on the 'SSN' field and filtering for accidents in 'Delhi'. Then, you would need to select the drivers from the 'Person' table who are not in the list of drivers who had an accident in 'Delhi'.

Here is the SQL query for this:

```sql
SELECT name 
FROM Database.Person 
WHERE SSN NOT IN (
    SELECT SSN 
    FROM Database.Accident 
    JOIN Database.Person ON Database.Accident.SSN = Database.Person.SSN 
    WHERE city = 'Delhi'
)
```

2) To find the cars sold in 2006 and whose owners are from Vadodara, you would need to join the 'Person' and 'Car' tables on the 'SSN' field and filter for cars sold in 2006 and persons from Vadodara.

Here is the SQL query for this:

```sql
SELECT license_no, year, model 
FROM Database.Car 
JOIN Database.Person ON Database.Car.SSN = Database.Person.SSN 
WHERE year = 2006 AND city = 'Vadodara'
```

3) To find out how many different models of car are used by Mr.abc, you would need to join the 'Person' and 'Car' tables on the 'SSN' field and filter for the person named 'Mr.abc'. Then, you would need to count the distinct models of cars.

Here is the SQL query for this:

```sql
SELECT COUNT(DISTINCT model) 
FROM Database.Car 
JOIN Database.Person ON Database.Car.SSN = Database.Person.SSN 
WHERE name = 'Mr.abc'
```

Question

Solution

Similar Questions

Upgrade your grade with Knowee