$1\mathrm{.}6$Build a detailed list of crimes against Property reported to have occurred in district $2$ 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 "crime$\_$against" column equals "Property".

Build a community$-$area 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.

$1\mathrm{.}8$List the crimes reported to have occurred at exactly $9$:$00$ am on October $11,2018.$

Show the title from the FBI$\_$code 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 #$25.$ 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 #$25$ with an IUCR primary description of "CRIM SEXUAL ASSAULT".

Show the primary$\_$description, secondary$\_$description, district, arrest, case$\_$number, commander, district phone number, community area number, and block.

Sort the results by secondary description then by district then by arrest then by case$\_$number.

$1\mathrm{.}10$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 primary$\_$description, secondary$\_$description, date, FBI code, and location description.

Sort the results by arrest then by secondary description then by crime$\_$id