use Join ON ,from, where, order . first join the table and make a relation between them and then where and order them
1.1 Build a community-area crime report showing each incident of public peace violation. a. Include crimes reported in Chicago's side named "North Side with a primary description of "PUBLIC PEACE VIOLATION". b. Show the community area name, secondary description, arrest, report number, beat, and block columns. Sort the results by community area name then by arrest then by secondary description then by report number 10 1.2 List the crimes reported to have occurred at exactly 10:00 am on July 2, 2018. a. Show the title from the FBI code table, ward number, district number, report number, community area number, and arrest. b. Sort the results by district number then by ward number then by title then by report number.! I 10 1.3 Suppose you work for alderman Carlos Ramirez-Rosa in the office of ward #35. The alderman would like to discuss progress on the cases of a particular category of crime with commanders of the districts where the crimes occurred. Generate a list to facilitate this discussion a. List all crimes reported in ward #35 with an IUCR primary description of "WEAPONS VIOLATION". b. Show the primary description, secondary description, district number, arrest, case number, commander, district phone number, block, and date. c Sort the results by district number then by secondary description then by arrest then by case number 10 1.4 Suppose you live in the New City neighborhood and are concerned about the rise in a particular category of crime. You have a meeting scheduled with a member of your alderman's staff to discuss the issue. To prepare for the meeting, you need to prepare a list of the crimes. a List all crimes reported in the community area associated with your neighborhood (New City) with an IUCR primary description of "INTERFERENCE WITH PUBLIC OFFICER". b. Show the primary description, secondary description, arrest, report number, date, location description, and block Sort the results by arrest then by secondary description then by report number. atlas-query/crime-chicago-2018 0 community area o community area_no community_area_name o side o population crime o report_no o case_number o date o block oiucr_no o location_description arrest o domestic beat o district_no ward_no o community_area_no ofbi_code_no latitude o longitude o location district o district_no district_name o address o zip_code commander email o phone fax otty o twitter fbi_code fbi_code_no title o description crime against lucr iucr_no o primary.description secondary_description index_code O o O . D . o . o O O O neighborhood o neighborhood name o community_area_no ward ward_no alderman_first_name alderman_last_name alderman_name_suffix ward_office_address ward_office_zip ward_email ward_office_phone ward_office_fax city_hall_office_room city_hall_office_phone city_hall_office_fax population O O O o 1.1 Build a community-area crime report showing each incident of public peace violation. a. Include crimes reported in Chicago's side named "North Side with a primary description of "PUBLIC PEACE VIOLATION". b. Show the community area name, secondary description, arrest, report number, beat, and block columns. Sort the results by community area name then by arrest then by secondary description then by report number 10 1.2 List the crimes reported to have occurred at exactly 10:00 am on July 2, 2018. a. Show the title from the FBI code table, ward number, district number, report number, community area number, and arrest. b. Sort the results by district number then by ward number then by title then by report number.! I 10 1.3 Suppose you work for alderman Carlos Ramirez-Rosa in the office of ward #35. The alderman would like to discuss progress on the cases of a particular category of crime with commanders of the districts where the crimes occurred. Generate a list to facilitate this discussion a. List all crimes reported in ward #35 with an IUCR primary description of "WEAPONS VIOLATION". b. Show the primary description, secondary description, district number, arrest, case number, commander, district phone number, block, and date. c Sort the results by district number then by secondary description then by arrest then by case number 10 1.4 Suppose you live in the New City neighborhood and are concerned about the rise in a particular category of crime. You have a meeting scheduled with a member of your alderman's staff to discuss the issue. To prepare for the meeting, you need to prepare a list of the crimes. a List all crimes reported in the community area associated with your neighborhood (New City) with an IUCR primary description of "INTERFERENCE WITH PUBLIC OFFICER". b. Show the primary description, secondary description, arrest, report number, date, location description, and block Sort the results by arrest then by secondary description then by report number. atlas-query/crime-chicago-2018 0 community area o community area_no community_area_name o side o population crime o report_no o case_number o date o block oiucr_no o location_description arrest o domestic beat o district_no ward_no o community_area_no ofbi_code_no latitude o longitude o location district o district_no district_name o address o zip_code commander email o phone fax otty o twitter fbi_code fbi_code_no title o description crime against lucr iucr_no o primary.description secondary_description index_code O o O . D . o . o O O O neighborhood o neighborhood name o community_area_no ward ward_no alderman_first_name alderman_last_name alderman_name_suffix ward_office_address ward_office_zip ward_email ward_office_phone ward_office_fax city_hall_office_room city_hall_office_phone city_hall_office_fax population O O O o
