Can you provide a count of assessment notes by teacher id?
select t1.teacher_id, count ( * ) from assessment_notes as t1 join teachers as t2 on t1.teacher_id = t2.teacher_id group by t1.teacher_id
For that table, can you sort by descending count?
select t1.teacher_id, count ( * ) 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
Can you left join the Assessment Notes table with the Teachers table on teacher_id?
select * from assessment_notes as t1 join teachers as t2 on t1.teacher_id = t2.teacher_id
For the earlier table with sorted counts, can you give me the first name associted with each teacher_id?
select t2.first_name, t1.teacher_id, count ( * ) 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