-- Database schema
| Ref_Address_Types : address_type_code [ TEXT ] primary_key , address_type_description [ TEXT ] | Ref_Detention_Type : detention_type_code [ TEXT ] primary_key , detention_type_description [ TEXT ] | Ref_Incident_Type : incident_type_code [ TEXT ] primary_key , incident_type_description [ TEXT ] | Addresses : address_id [ INT ] primary_key , line_1 [ TEXT ] , line_2 [ TEXT ] , line_3 [ TEXT ] , city [ TEXT ] , zip_postcode [ TEXT ] , state_province_county [ TEXT ] , country [ TEXT ] , other_address_details [ TEXT ] | Students : student_id [ INT ] primary_key , address_id [ INT ] Students.address_id = Addresses.address_id , first_name [ TEXT ] , middle_name [ TEXT ] , last_name [ TEXT ] , cell_mobile_number [ TEXT ] , email_address [ TEXT ] , date_first_rental [ TEXT ] , date_left_university [ TEXT ] , other_student_details [ TEXT ] | Teachers : teacher_id [ INT ] primary_key , address_id [ INT ] Teachers.address_id = Addresses.address_id , first_name [ TEXT ] , middle_name [ TEXT ] , last_name [ TEXT ] , gender [ TEXT ] , cell_mobile_number [ TEXT ] , email_address [ TEXT ] , other_details [ TEXT ] | Assessment_Notes : notes_id [ INT ] , student_id [ INT ] Assessment_Notes.student_id = Students.student_id , teacher_id [ INT ] Assessment_Notes.teacher_id = Teachers.teacher_id , date_of_notes [ TEXT ] , text_of_notes [ TEXT ] , other_details [ TEXT ] | Behavior_Incident : incident_id [ INT ] primary_key , incident_type_code [ TEXT ] Behavior_Incident.incident_type_code = Ref_Incident_Type.incident_type_code , student_id [ INT ] Behavior_Incident.student_id = Students.student_id , date_incident_start [ TEXT ] , date_incident_end [ TEXT ] , incident_summary [ TEXT ] , recommendations [ TEXT ] , other_details [ TEXT ] | Detention : detention_id [ INT ] primary_key , detention_type_code [ TEXT ] Detention.detention_type_code = Ref_Detention_Type.detention_type_code , teacher_id [ INT ] Detention.teacher_id = Teachers.teacher_id , datetime_detention_start [ TEXT ] , datetime_detention_end [ TEXT ] , detention_summary [ TEXT ] , other_details [ TEXT ] | Student_Addresses : student_id [ INT ] Student_Addresses.student_id = Students.student_id , address_id [ INT ] Student_Addresses.address_id = Addresses.address_id , date_address_from [ TEXT ] , date_address_to [ TEXT ] , monthly_rental [ INT ] , other_details [ TEXT ] | Students_in_Detention : student_id [ INT ] Students_in_Detention.student_id = Students.student_id , detention_id [ INT ] Students_in_Detention.detention_id = Detention.detention_id , incident_id [ INT ] Students_in_Detention.incident_id = Behavior_Incident.incident_id |
-- -- What is the incident type description for the incident type with code "VIOLENCE"?

SELECT incident_type_description FROM Ref_Incident_Type WHERE incident_type_code  =  "VIOLENCE";