To solve this task, you would need to use SQL (Structured Query Language). Here is a step-by-step guide on how to write the query:

1. First, you need to join the `Persons` table with the `Knows` table twice, once for `personA_id` and once for `personB_id`. This will allow you to access the age of the people that `personA` knows.

2. Then, you need to filter the results to only include rows where the person that `personA` knows is older than 60.

3. After that, you need to group the results by `personA_id` and count the number of people that each person knows.

4. Finally, you need to filter the results again to only include rows where the count is exactly 2.

Here is the SQL query that accomplishes this:

```sql
SELECT pA.name
FROM Persons pA
JOIN Knows k ON pA.id = k.personA_id
JOIN Persons pB ON k.personB_id = pB.id
WHERE pB.age 60
GROUP BY pA.id
HAVING COUNT(*) = 2
```

This query will return the names of all people that know exactly 2 people who are older than 60.

Question

To solve this task, you would need to use SQL (Structured Query Language). Here is a step-by-step guide on how to write the query:

1. First, you need to join the `Persons` table with the `Knows` table twice, once for `personA_id` and once for `personB_id`. This will allow you to access the age of the people that `personA` knows.

2. Then, you need to filter the results to only include rows where the person that `personA` knows is older than 60.

3. After that, you need to group the results by `personA_id` and count the number of people that each person knows.

4. Finally, you need to filter the results again to only include rows where the count is exactly 2.

Here is the SQL query that accomplishes this:

```sql
SELECT pA.name
FROM Persons pA
JOIN Knows k ON pA.id = k.personA_id
JOIN Persons pB ON k.personB_id = pB.id
WHERE pB.age > 60
GROUP BY pA.id
HAVING COUNT(*) = 2
```

This query will return the names of all people that know exactly 2 people who are older than 60.

Knowee AI · Accepted Answer

To solve this task, you would need to use SQL (Structured Query Language). Here is a step-by-step guide on how to write the query:

1. First, you need to join the `Persons` table with the `Knows` table twice, once for `personA_id` and once for `personB_id`. This will allow you to access the age of the people that `personA` knows.

2. Then, you need to filter the results to only include rows where the person that `personA` knows is older than 60.

3. After that, you need to group the results by `personA_id` and count the number of people that each person knows.

4. Finally, you need to filter the results again to only include rows where the count is exactly 2.

Here is the SQL query that accomplishes this:

```sql
SELECT pA.name
FROM Persons pA
JOIN Knows k ON pA.id = k.personA_id
JOIN Persons pB ON k.personB_id = pB.id
WHERE pB.age > 60
GROUP BY pA.id
HAVING COUNT(*) = 2
```

This query will return the names of all people that know exactly 2 people who are older than 60.

This task concerns the following tables:PersonsidnameaddressageeyeColorgenderKnowsidpersonA_id → PersonspersonB_id → PersonsThe semantics of the Knows table is that personA knows personB.Write a query that returns the name of all people that know precisely 2 people that are older than 60.

Question

Solution

Similar Questions

Upgrade your grade with Knowee