$1\mathrm{.}1$ Make a community$-$area neighborhood list.

a$.$ Show the side, community area name, and the name of the

neighborhood.

b$.$ Sort the results by side then by community area name then

by neighborhood

$1\mathrm{.}2$ List the crimes reported to have occurred at residences

in ward $31$ with a IUCR primary description of "CRIMINAL

TRESPASS".

Show the secondary description, district, date, and

case$\_$number.

Crimes occurring at residences have a location that starts

with "residen".

Sort the results by district then by secondary description.

$1\mathrm{.}3$ List the crimes reported with a primary description of

"INTERFERENCE WITH PUBLIC OFFICER" that occurred in ward

#$22$ where an arrest has been made.

Show the primary description, ward, district, community

area number, and location description.

Sort the results by primary description then by district then

by ward.

$1\mathrm{.}4$ List the crimes reported between latitudes $41\mathrm{.}948$ and

$41\mathrm{.}949($inclusive$)$ that have a location description of "BAR OR

TAVERN".

Show the title from the FBI$\_$code table, ward, district, FBI

code, and case number.

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

$1\mathrm{.}5$ Build a detailed list of all crimes reported to have

occurred in locations under management of the Chicago

Housing Authority in ward number $16$ where no arrest has been

made.

Show the case number, IUCR primary description, IUCR

secondary description, block, and beat.

Order the result by secondary description then primary

description then case number.

Note: locations under the management of the Chicago

Housing Authority begin with "CHA". $1\mathrm{.}6$ Build a detailed list of crimes against Persons reported

to have occurred in district $2$ at locations with a description of

"GAS STATION".

Show the case number, IUCR primary description, IUCR

secondary description, block, and community area number.

Order the result by primary description then secondary

description.

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

equals "Persons".

$1\mathrm{.}7$ Build a community$-$area crime report showing each

incident of obscenity.

Include crimes reported in Chicago's "South" side with a

primary description of "OBSCENITY".

Show the community area name, secondary description,

arrest, ward, and district columns.

Sort the results by arrest then by community area name

then by secondary description.

$1\mathrm{.}8$ List the crimes reported to have occurred at exactly

$9$:$00$ am on August $19,2018.$

Show the title from the FBI$\_$code table, ward, district, block,

and case number.

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

$()10$

$1\mathrm{.}9$ Suppose you work for alderman Harry Osterman in the

office of ward #$48.$ 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 #$48$ with an IUCR primary

description of "SEX OFFENSE".

Show the primary$\_$description, secondary$\_$description,

district, arrest, case$\_$number, commander, district phone

number, community area number, and location description.

Sort the results by secondary description then by district

then by case$\_$number then by arrest.

$()10$

$1\mathrm{.}10$ Suppose you live in the Wildwood 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 $($Wildwood$)$ with an IUCR primary

description of "ASSAULT".

Show the primary$\_$description, secondary$\_$description, date,

block, and beat.

Sort the results by secondary description then by arrest

then by crime$\_$id$.$