ค้นหานักเรียนชั้นประถมศึกษาปีที่ 1 ที่ไม่ได้สอนโดย OTHA MOYER แจ้งชื่อและนามสกุล ไม่จำเป็นต้องใช้ทุกตาราง
Find all first-grade students who are NOT taught by OTHA MOYER. Report their first and last names.It is not neccessary to use all the tables.
 list:  (firstname [ VARCHAR ] lastname [ VARCHAR ] classroom [ VARCHAR ] grade [ VARCHAR) ]
SELECT DISTINCT T1.firstname, T1.lastname 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"