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

Count the number of clubs located at 'HHH'.
SELECT COUNT(*) FROM club WHERE clublocation = "HHH"
SELECT COUNT(*) FROM "club" WHERE "HHH" = "clublocation"