CREATE TABLE club (clubid NUMBER, clubname CLOB, clubdesc CLOB, clublocation CLOB)
CREATE TABLE member_of_club (stuid NUMBER, clubid NUMBER, position CLOB)
CREATE TABLE student (stuid NUMBER, lname CLOB, fname CLOB, age NUMBER, sex CLOB, major NUMBER, advisor NUMBER, city_code CLOB)

What are the names of the clubs that have 'Davis Steven' as a member?
SELECT DISTINCT t1.clubname FROM club AS t1 JOIN member_of_club AS t2 ON t1.clubid = t2.clubid JOIN student AS t3 ON t2.stuid = t3.stuid WHERE t3.fname = "Davis" AND t3.lname = "Steven"
SELECT DISTINCT "t1"."clubname" FROM "club" "t1" JOIN "member_of_club" "t2" ON "t1"."clubid" = "t2"."clubid" JOIN "student" "t3" ON "Davis" = "t3"."fname" AND "Steven" = "t3"."lname" AND "t2"."stuid" = "t3"."stuid"