Can you list the class room associated with the name Loria Ondersma in the teachers table?
select classroom from teachers where lastname = "ONDERSMA"
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
Can you tell me how many unique names are currently in the table?
select count ( distinct firstname ) from teachers
How many unique names in the list table have a classroom id of 108?
select count ( distinct firstname ) from teachers where classroom = 108