CREATE TABLE races (raceid VARCHAR2, name VARCHAR2)
CREATE TABLE results (driverid VARCHAR2, raceid VARCHAR2)
CREATE TABLE drivers (forename VARCHAR2, driverid VARCHAR2)

Find the id and forenames of drivers who participated both the races with name Australian Grand Prix and the races with name Chinese Grand Prix?
SELECT T2.driverid, T3.forename FROM races AS T1 JOIN results AS T2 ON T1.raceid = T2.raceid JOIN drivers AS T3 ON T2.driverid = T3.driverid WHERE T1.name = "Australian Grand Prix" INTERSECT SELECT T2.driverid, T3.forename FROM races AS T1 JOIN results AS T2 ON T1.raceid = T2.raceid JOIN drivers AS T3 ON T2.driverid = T3.driverid WHERE T1.name = "Chinese Grand Prix"
SELECT "T2"."driverid", "T3"."forename" FROM "races" "T1" JOIN "results" "T2" ON "T1"."raceid" = "T2"."raceid" JOIN "drivers" "T3" ON "T2"."driverid" = "T3"."driverid" WHERE "Australian Grand Prix" = "T1"."name" INTERSECT SELECT "T2"."driverid", "T3"."forename" FROM "races" "T1" JOIN "results" "T2" ON "T1"."raceid" = "T2"."raceid" JOIN "drivers" "T3" ON "T2"."driverid" = "T3"."driverid" WHERE "Chinese Grand Prix" = "T1"."name"