CREATE TABLE student (name VARCHAR2, id VARCHAR2)
CREATE TABLE course (course_id VARCHAR2, dept_name VARCHAR2)
CREATE TABLE takes (course_id VARCHAR2, id VARCHAR2)

Find the name of students who took some course offered by Statistics department.
SELECT T3.name FROM course AS T1 JOIN takes AS T2 ON T1.course_id = T2.course_id JOIN student AS T3 ON T2.id = T3.id WHERE T1.dept_name = 'Statistics'
SELECT "T3"."name" FROM "course" "T1" JOIN "takes" "T2" ON "T1"."course_id" = "T2"."course_id" JOIN "student" "T3" ON "T2"."id" = "T3"."id" WHERE "T1"."dept_name" = 'Statistics'