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

Show each student's first name and last name.
SELECT DISTINCT firstname, lastname FROM list
SELECT DISTINCT "firstname", "lastname" FROM "list"