use the compound join, where, and wildcard SQL query to solve the problem, we have the tables attached and the required question

1.11 Make a community-area neighborhood list. a. Show the side, community area name, and the name of the neighborhood. b. Sort the results by side then by community area name then by neighborhood 10 1.2 List the crimes reported to have occurred at residences in ward 7 with a IUCR primary description of "SEX OFFENSE. a. Show the secondary description, district number, beat, and case number. b. Crimes occurring at residences have a location that starts with resident c. Sort the results by secondary description then by district number then by case number. 10 1.3 List the crimes reported with a primary description of "ARSON that occurred in ward #17 where no arrest has been made a. Show the primary description, ward number, district number, case number, date, and location description b. Sort the results by primary description then by district number then by ward number then by case number. 10 1.4 List the crimes reported between latitudes 41.921 and 41.922 (inclusive) that have a location description of "OTHER". a. Show the title from the FBI code table, ward number, district number, report number, community area number, and date. b. Sort the results by district number then by title then by ward number then by report number. 10 1.5 Build a detailed list of all crimes reported to have occurred in locations under management of the Chicago Transit Authority in ward number 14 where an arrest has been made. Show the case number, location description, IUCR primary description, district number, and community area number. Order the result by primary description then secondary description then by case number Note: locations under the management of the Chicago Transit Authority begin with "CTA. . 10 atlas-query/crime-chicago-2018 community area o community area no community area name side population crime report no o case_number date block lucr_no location description arrest o domestic beat district no ward_no community area no fi code no latitude longitude location district district.no district name address zip code commander email phone 1 ty twitter fbl code fbi.code.no . description crime against lucr lucr_no primary description Secondary description index_code neighborhood o neighborhood name o community_area_no ward ward_no o alderman_first_name alderman_last name o alderman_name_suffix ward_office_address ward_office_zip ward email oward_office_phone ward_office_fax o city hall_office_room city_hall_office_phone o city hall office fax population Focus tates)