CREATE TABLE list (lastname CLOB, firstname CLOB, grade NUMBER, classroom NUMBER)
CREATE TABLE teachers (lastname CLOB, firstname CLOB, classroom NUMBER)

How many students are there?
SELECT COUNT(*) FROM list
SELECT COUNT(*) FROM "list"