SELECT DISTINCT firstname FROM list WHERE classroom  =  107
List the first names of all the students in room 107.
SELECT DISTINCT firstname FROM list WHERE classroom = 107
select distinct firstname from list where classroom = value
List the first names of all the students in room 107 .