What behavior incident types are there?
select incident_type_code from behavior_incident group by incident_type_code
How many behavior incidents are there?
select count(*) from behavior_incident
How many does each student have?
select student_id, count(*) from behavior_incident group by student_id
Show me the id and last name of the one with the largest number.
select t1.student_id, t2.last_name from behavior_incident as t1 join students as t2 on t1.student_id = t2.student_id group by t1.student_id order by count(*) desc limit 1