
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
*/
Report the first name and last name of all the teachers.
SELECT DISTINCT firstname ,  lastname FROM teachers
[{'FirstName': ' JEROME', 'LastName': 'COVIN'}, {'FirstName': ' GORDON', 'LastName': 'KAWA'}, {'FirstName': ' BILLIE', 'LastName': 'KRIENER'}, {'FirstName': ' MIN', 'LastName': 'MACROSTIE'}, {'FirstName': ' KIRK', 'LastName': 'MARROTTE'}, {'FirstName': ' OTHA', 'LastName': 'MOYER'}, {'FirstName': ' JERLENE', 'LastName': 'NIBLER'}, {'FirstName': ' LORIA', 'LastName': 'ONDERSMA'}, {'FirstName': ' ALFREDA', 'LastName': 'SUGAI'}, {'FirstName': ' GEORGETTA', 'LastName': 'SUMPTION'}, {'FirstName': ' LEIA', 'LastName': 'TARRING'}, {'FirstName': ' CHARMAINE', 'LastName': 'URSERY'}]