Can you show me all first and last names from the list table that have a classroom id of 108?
SELECT firstname, lastname from teachers where classroom  =  108
first and last names refer to firstname, lastname; have a classroom id of 108 refers to classroom = 108;