Answered step by step
Verified Expert Solution
Question
1 Approved Answer
(1.9) Suppose you work for alderman Ariel Reboyras in the office of ward #30. The alderman would like to discuss progress on the cases of
(1.9) Suppose you work for alderman Ariel Reboyras in the office of ward \#30. 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. List all crimes reported in ward \#30 with an IUCR primary description of "OFFENSE INVOLVING CHILDREN". - Show the primary_description, secondary_description, district, arrest, case_number, commander, district phone number, beat, and FBI code. - Sort the results by secondary description then by district then by case_number then by arrest. (1.10) Suppose you live in the Homan Square 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. - List all crimes reported in the community area associated with your neighborhood (Homan Square) with an IUCR primary description of "HOMICIDE". - Show the primary_description, secondary_description, date, location description, and beat. - Sort the results by secondary description then by arrest then by crime_id
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