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

Count the total number of students.
SELECT COUNT(*) FROM student
SELECT COUNT(*) FROM "student"