How Many Students have Behavior Incident reports with recommendations?
select count ( * ) from ( select * from behavior_incident as t1 join students as t2 on t1.student_id = t2.student_id group by t1.student_id )
How many of those Recommendations required the students to leave the university?
select count ( * ) from ( select * from behavior_incident as t1 join students as t2 on t1.student_id = t2.student_id where recommendations = "Transfer schools" group by t1.student_id )
What was the students last name and ID that had the most behavior incidents?
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