This database contains data about crimes reported in the city of Chicago during $2018.$

$1\mathrm{.}1$

Make a community$-$area neighborhood list.

Show the side, community area name, and the name of the neighborhood.

Sort the results by side then by community area name then by neighborhood

$10$

$1\mathrm{.}2$

List the crimes reported to have occurred at residences in ward $28$ with a IUCR primary description of "MOTOR VEHICLE THEFT".

Show the secondary description, district number, beat, and date.

Crimes occurring at residences have a location that starts with "residen".

Sort the results by secondary description then by district number then by case number.

$10$

$1\mathrm{.}3$

List the crimes reported with a primary description of "MOTOR VEHICLE THEFT" that occurred in ward #$7$ where an arrest has been made.

Show the primary description, ward number, district number, case$\_$number, location description, and block.

Sort the results by district number then by ward number then by primary description then by case$\_$number.

$10$

$1\mathrm{.}4$

List the crimes reported between latitudes $41\mathrm{.}983$ and $41\mathrm{.}984($inclusive$)$ that have a location description of "RESTAURANT".

Show the title from the FBI$\_$code table, ward number, district number, report$\_$number, community area number, and block.

Sort the results by ward number then by district number then by title then by report number.

$10$

$1\mathrm{.}5$

Build a detailed list of all crimes reported to have occurred in locations under management of the Chicago Transit Authority in ward number $11$ where an arrest has been made.

Show the case number, location description, IUCR primary description, IUCR secondary description, and block.

Order the result by secondary description then primary description then by case number.

Note: locations under the management of the Chicago Transit Authority begin with "CTA".

$10$

$1\mathrm{.}6$

Build a detailed list of crimes against Society reported to have occurred in district #$22$ at locations with a description of "PARK PROPERTY".

Show the case number, IUCR primary description, IUCR secondary description, community area number, and beat.

Order the result by secondary description then primary description then by case number.

Note: Only include crimes where the "crime$\_$against" column equals "Society".

$10$

$1\mathrm{.}7$

Build a community$-$area crime report showing each incident of arson.

Include crimes reported in Chicago's side named "South" with a primary description of "ARSON".

Show the community area name, secondary description, arrest, report$\_$number, beat, and ward number columns.

Sort the results by arrest then by community area name then by secondary description then by report number.

$10$

$1\mathrm{.}8$

List the crimes reported to have occurred at exactly $9$:$00$ am on February $17,2018.$

Show the title from the FBI$\_$code table, ward number, district number, report number, case number, and location description.

Sort the results by ward number then by district number then by title then by report number.

$10$

$1\mathrm{.}9$

Suppose you work for alderman Michael Scott in the office of ward #$24.$ 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 #$24$ with an IUCR primary description of "HOMICIDE".

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

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

$10$

$1\mathrm{.}10$

Suppose you live in the Chicago Lawn 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 $($Chicago Lawn$)$ with an IUCR primary description of "HOMICIDE".

Show the primary$\_$description, secondary$\_$description, arrest, report number, date, block, and location description.

Sort the results by secondary description then by arrest then by report number.