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
ids and first names of the 3 teachers that have the most number of assessment notes refers to SELECT T1.teacher_id, T2.first_name GROUP BY T1.teacher_id ORDER BY COUNT(*) DESC LIMIT 3; joining Assessment_Notes and Teachers tables refers to JOIN on T1.teacher_id = T2.teacher_id;