Answered step by step
Verified Expert Solution
Question
1 Approved Answer
1 . 6 Build a detailed list of crimes against Property reported to have occurred in district 2 at locations with a description of CONSTRUCTION
Build a detailed list of crimes against Property reported to have occurred in district at locations with a description of "CONSTRUCTION SITE".
Show the case number, IUCR primary description, IUCR secondary description, beat, and block.
Order the result by secondary description then primary description.
Note: Only include crimes where the "crimeagainst" column equals "Property".
Build a communityarea crime report showing each incident of kidnapping.
Include crimes reported in Chicago's "Southwest" side with a primary description of "KIDNAPPING".
Show the community area name, secondary description, arrest, FBI code, and ward columns.
Sort the results by community area name then by arrest then by secondary description.
List the crimes reported to have occurred at exactly : am on October
Show the title from the FBIcode table, ward, district, IUCR, and community area number.
Sort the results by title then by district then by ward
Suppose you work for alderman Byron Lopez in the office of ward # 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 # with an IUCR primary description of "CRIM SEXUAL ASSAULT".
Show the primarydescription, secondarydescription, district, arrest, casenumber, commander, district phone number, community area number, and block.
Sort the results by secondary description then by district then by arrest then by casenumber.
Suppose you live in the Canaryville 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 Canaryville with an IUCR primary description of "INTERFERENCE WITH PUBLIC OFFICER".
Show the primarydescription, secondarydescription, date, FBI code, and location description.
Sort the results by arrest then by secondary description then by crimeid
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