How many unique names in the list table have a classroom id of 108?
SELECT count ( distinct firstname )  from teachers where classroom  =  108
unique names refers to COUNT(DISTINCT firstname); classroom id of 108 refers to classroom = 108;