Answered step by step
Verified Expert Solution
Question
1 Approved Answer
I need help finding the queries for questions 1.5-1.10. Thank you! 1.5 List the crimes reported with an IUCR NUMBER of 5011 that occurred in
I need help finding the queries for questions 1.5-1.10. Thank you!
1.5 List the crimes reported with an IUCR NUMBER of "5011" that occurred in ward NUMBER 9 where no arrest has been made. - Show the date, case number, district number, and FBI code. - Sort the results by date then by case number. (D) (1.6) List the crimes reported in district \#10 where no location description has been reported. - Show the date, case number, community area number, and district number. - Sort the results by case number then by date. 1.7 List the crimes reported in district \#3 with an IUCR number of 1122 along with those reported in ward \#48 with an FBI code number of 15. - Show the case number, FBI code number, ward number, IUCR number, district number, location description, and arrest. - Sort the results by IUCR number then by district number then by FBI code number then by ward number then by case number. 1.8) List the crimes reported between latitudes 41.83 and 41.831 (inclusive) that have a location description of "WAREHOUSE". - Show the date, case number, community area number, and FBI code. - Sort the results by date then by case number. 1.9 Which wards had at least one crime with an IUCR number of "1310" (CRIMINAL DAMAGE) reported at a location with a description of "ABANDONED BUILDING"? - Show only the ward number in ascending order. Be sure your result does not include any duplicates. (1.10) List the location descriptions where crimes with an IUCR number of "2820" (OTHER OFFENSE) have occurred in ward \#47. - Show only the location_description in alphabetical order. - Be sure your result does not include any duplicates. community_area \# community_area_no (i) community_area_nam (i) e side (i) \# population (i) crime \# report_no (i) case_number (i) date (i) block (i) iucr_no (i) location_description (i) (D arrest (i) ( ) domestic (i) # beat (i) \# district_no (i) \# ward_no (i) \# community_area_no (i) fbi_code_no (i) \# latitude (i) \# longitude location district \# district_no (i) district_name (i) address district \# district_no (i) district_name (i) address (i) \# zip_code (i) commander (i) email (i) phone (i) fax (i) tty (i) twitter (i) fbi_code fbi_code_no (i) title (i) description (i) crime_against (i) iucr iucr_no (i) primary_description secondary_description index_code (i) neighborhood neighborhood_name \# community_area_no ward ward_no (i) alderman_first_name alderman_last_name alderman_name_suffix ward_office_address (i) ward_office_zip (i) ward_email (i) ward_office_phone (i) ward_office_fax (i) city_hall_office_room (i) city_hall_office_phone city_hall_office_fax (i) population (i)Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started