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)
CREATE TABLE club (clubid NUMBER, clubname CLOB, clubdesc CLOB, clublocation CLOB)

What are the names of all clubs?
SELECT clubname FROM club
SELECT "clubname" FROM "club"