
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
*/
For each classroom, report the classroom number and the number of grades using it.
SELECT classroom ,  count(DISTINCT grade) FROM list GROUP BY classroom
[{'Classroom': 101, 'count(DISTINCT grade)': 1}, {'Classroom': 102, 'count(DISTINCT grade)': 1}, {'Classroom': 103, 'count(DISTINCT grade)': 1}, {'Classroom': 104, 'count(DISTINCT grade)': 1}, {'Classroom': 105, 'count(DISTINCT grade)': 1}, {'Classroom': 106, 'count(DISTINCT grade)': 1}, {'Classroom': 107, 'count(DISTINCT grade)': 1}, {'Classroom': 108, 'count(DISTINCT grade)': 1}, {'Classroom': 109, 'count(DISTINCT grade)': 1}, {'Classroom': 110, 'count(DISTINCT grade)': 1}, {'Classroom': 111, 'count(DISTINCT grade)': 1}, {'Classroom': 112, 'count(DISTINCT grade)': 1}]