Find the start date of behavior incidents of students with the last name "Fahey"?
select t1.date_incident_start from behavior_incident as t1 join students as t2 on t1.student_id = t2.student_id where t2.last_name = "Fahey"
Find the incident type code of behavior incidents of students with the last name "Fahey"?
select t1.incident_type_code from behavior_incident as t1 join students as t2 on t1.student_id = t2.student_id where t2.last_name = "Fahey"
What is the date left university of the student with the last name "Fahey"?
select t2.date_left_university from behavior_incident as t1 join students as t2 on t1.student_id = t2.student_id where t2.last_name = "Fahey"
How many students have the incident type code "VIOLENCE"?
select count ( * ) from behavior_incident where incident_type_code = "VIOLENCE"
Both, please.
select t2.first_name, t2.last_name from behavior_incident as t1 join students as t2 on t1.student_id = t2.student_id where t1.incident_type_code = "VIOLENCE"