CREATE TABLE personfriend (name CLOB, friend CLOB, year NUMBER)
CREATE TABLE person (name CLOB, age NUMBER, city CLOB, gender CLOB, job CLOB)

Find the name and age of the person who is a friend of both Dan and Alice.
SELECT T1.name, T1.age FROM person AS T1 JOIN personfriend AS T2 ON T1.name = T2.name WHERE T2.friend = 'Dan' INTERSECT SELECT T1.name, T1.age FROM person AS T1 JOIN personfriend AS T2 ON T1.name = T2.name WHERE T2.friend = 'Alice'
SELECT "T1"."name", "T1"."age" FROM "person" "T1" JOIN "personfriend" "T2" ON "T1"."name" = "T2"."name" AND "T2"."friend" = 'Dan' INTERSECT SELECT "T1"."name", "T1"."age" FROM "person" "T1" JOIN "personfriend" "T2" ON "T1"."name" = "T2"."name" AND "T2"."friend" = 'Alice'