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)
)
SELECT grade ,  count(DISTINCT classroom) ,  count(*) FROM list GROUP BY grade
For each grade, report the grade, the number of classrooms in which it is taught and the total number of students in the grade.