SELECT DISTINCT firstname FROM list WHERE classroom  =  107
What are the first names of students studying in room 107?
SELECT DISTINCT firstname FROM list WHERE classroom = 107
select distinct firstname from list where classroom = value
What are the first names of students studying in room 107 ?