What behavior incident types are there?
select incident_type_code from behavior_incident group by incident_type_code
How many behavior incidents are there in terms of each type?
select incident_type_code,count(*) from behavior_incident group by incident_type_code
Show me the code and description of the most frequent one of them.
select t1.incident_type_code, t2.incident_type_description from behavior_incident as t1 join ref_incident_type as t2 on t1.incident_type_code = t2.incident_type_code group by t1.incident_type_code order by count(*) desc limit 1