SELECT lastname FROM list WHERE classroom  =  111
Find the last names of students studying in room 111.
SELECT lastname FROM list WHERE classroom = 111
select lastname from list where classroom = value
Find the last names of students studying in room 111 .