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

Report the first name and last name of all the teachers.
SELECT DISTINCT firstname, lastname FROM teachers
SELECT DISTINCT "firstname", "lastname" FROM "teachers"