
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 the first and last name of all the teachers that teach EVELINA BROMLEY.
SELECT T2.firstname ,  T2.lastname FROM list AS T1 JOIN teachers AS T2 ON T1.classroom  =  T2.classroom WHERE T1.firstname  =  "EVELINA" AND T1.lastname  =  "BROMLEY"
[{'Nenhum': 'Nenhum resultado encontrado'}]