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)
CREATE TABLE member_of_club (stuid NUMBER, clubid NUMBER, position CLOB)

How many clubs are there?
SELECT COUNT(*) FROM club
SELECT COUNT(*) FROM "club"