How many students are there in the file?
select count(*) from list
Give me the classroom EVELINA BROMLEY is in.
select classroom from list where firstname = "EVELINA" and lastname = "BROMLEY"
Show me the name of teachers that teach in that classroom.
select t2.firstname, t2.lastname from list as t1 join teachers as t2 on t1.classroom = t2.classroom where t1.firstname = "EVELINA" and t1.lastname = "BROMLEY"