what is the average of grades?
select avg ( grade ) from list
can you show me a list of teacchers first name?
select firstname from teachers
can you show me a list of teachers first name that starting with 'M'?
select firstname from teachers where firstname like "M%"
first
select distinct t1.firstname from list as t1 join teachers as t2 on t1.classroom = t2.classroom where t1.grade = 1 except 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"