CREATE TABLE exhibition_record (date VARCHAR, attendance VARCHAR, exhibition_id VARCHAR)
CREATE TABLE exhibition (theme VARCHAR, exhibition_id VARCHAR, year VARCHAR)

What is the theme, date, and attendance for the exhibition in year 2004?
SELECT T2.theme, T1.date, T1.attendance FROM exhibition_record AS T1 JOIN exhibition AS T2 ON T1.exhibition_id = T2.exhibition_id WHERE T2.year = 2004
SELECT "T2"."theme", "T1"."date", "T1"."attendance" FROM "exhibition_record" AS "T1" JOIN "exhibition" AS "T2" ON "T1"."exhibition_id" = "T2"."exhibition_id" AND "T2"."year" = 2004