
CREATE TABLE list (
	"LastName" TEXT, 
	"FirstName" TEXT, 
	"Grade" INTEGER, 
	"Classroom" INTEGER, 
	PRIMARY KEY ("LastName", "FirstName")
)


CREATE TABLE teachers (
	"LastName" TEXT, 
	"FirstName" TEXT, 
	"Classroom" INTEGER, 
	PRIMARY KEY ("LastName", "FirstName")
)

CREATE TABLE list (
	"LastName" TEXT, 
	"FirstName" TEXT, 
	"Grade" INTEGER, 
	"Classroom" INTEGER, 
	PRIMARY KEY ("LastName", "FirstName")
)

/*
2 rows from list table:
LastName	FirstName	Grade	Classroom
CAR	 MAUDE	2	101
KRISTENSEN	 STORMY	6	112
*/


CREATE TABLE teachers (
	"LastName" TEXT, 
	"FirstName" TEXT, 
	"Classroom" INTEGER, 
	PRIMARY KEY ("LastName", "FirstName")
)

/*
2 rows from teachers table:
LastName	FirstName	Classroom
MACROSTIE	 MIN	101
COVIN	 JEROME	102
*/
Find all first-grade students who are NOT taught by OTHA MOYER. Report their first and last names.
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"
[{'FirstName': ' ANIKA', 'LastName': 'YUEN'}, {'FirstName': ' ANTONY', 'LastName': 'BRIGHTBILL'}, {'FirstName': ' CHANTAL', 'LastName': 'HANNEMANN'}, {'FirstName': ' EVELINA', 'LastName': 'BROMLEY'}, {'FirstName': ' KERI', 'LastName': 'TRAYWICK'}, {'FirstName': ' LANCE', 'LastName': 'HOOSOCK'}, {'FirstName': ' MARCUS', 'LastName': 'RUNKLE'}, {'FirstName': ' MEL', 'LastName': 'BALBOA'}, {'FirstName': ' PATRINA', 'LastName': 'AMY'}, {'FirstName': ' REYNALDO', 'LastName': 'BARTKUS'}, {'FirstName': ' RODGER', 'LastName': 'RANSLER'}, {'FirstName': ' SHANAE', 'LastName': 'BIBB'}]