
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 number of students in one classroom.
SELECT count(*) ,  classroom FROM list GROUP BY classroom
[{'count(*)': 3, 'Classroom': 101}, {'count(*)': 7, 'Classroom': 102}, {'count(*)': 5, 'Classroom': 103}, {'count(*)': 4, 'Classroom': 104}, {'count(*)': 5, 'Classroom': 105}, {'count(*)': 7, 'Classroom': 106}, {'count(*)': 6, 'Classroom': 107}, {'count(*)': 2, 'Classroom': 108}, {'count(*)': 8, 'Classroom': 109}, {'count(*)': 6, 'Classroom': 110}, {'count(*)': 4, 'Classroom': 111}, {'count(*)': 3, 'Classroom': 112}]