CREATE TABLE Assessment_Notes (teacher_id VARCHAR)
CREATE TABLE Teachers (first_name VARCHAR, teacher_id VARCHAR)

Find the ids and first names of the 3 teachers that have the most number of assessment notes?
SELECT T1.teacher_id, T2.first_name FROM Assessment_Notes AS T1 JOIN Teachers AS T2 ON T1.teacher_id = T2.teacher_id GROUP BY T1.teacher_id ORDER BY COUNT(*) DESC LIMIT 3
SELECT "T1"."teacher_id", "T2"."first_name" FROM "Assessment_Notes" AS "T1" JOIN "Teachers" AS "T2" ON "T1"."teacher_id" = "T2"."teacher_id" GROUP BY "T1"."teacher_id" ORDER BY COUNT(*) DESC NULLS LAST LIMIT 3