Show me the name of all teachers in record.
select firstname, lastname from teachers
Which classrooms does OTHA MOYER teach in?
select classroom from teachers where firstname = "OTHA" and lastname = "MOYER"
Show me the name of students who are in those classrooms.
select t1.firstname, t1.lastname from list as t1 join teachers as t2 on t1.classroom = t2.classroom where t2.firstname = "OTHA" and t2.lastname = "MOYER"