CREATE TABLE list (firstname VARCHAR, lastname VARCHAR)

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