Answered step by step
Verified Expert Solution
Link Copied!

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

image text in transcribedimage text in transcribedimage text in transcribedimage text in transcribedimage text in transcribedimage text in transcribed

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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Students also viewed these Databases questions

Question

64 Incident and emergency response plans.

Answered: 1 week ago

Question

How do modern Dashboards differ from earlier implementations?

Answered: 1 week ago