Hello! Can you please list all of the first and last names for all of the students in the database?
select lastname,firstname from list
Excellent!  Could you filter that list to show only the students who were taught by the teacher with the last name Moyer?
select t1.firstname, t1.lastname from list as t1 join teachers as t2 on t1.classroom = t2.classroom where t2.lastname = "MOYER"
Great!  Could you update this list to include the grade of each student?
select t1.firstname, t1.lastname,grade from list as t1 join teachers as t2 on t1.classroom = t2.classroom where t2.lastname = "MOYER"