$1\mathrm{.}1$ Make a community$-$area $1\mathrm{.}4$ List the crimes reported

between latitudes $41\mathrm{.}924$ and $41\mathrm{.}925$

$($inclusive$)$ that have a location

description of "WAREHOUSE".

Show the title from the FBI$\_$code

table, ward, district, case number,

and community area number.

Sort the results by title then by

ward then by district$\mathrm{.}1\mathrm{.}6$ Build a detailed list of crimes

against Property reported to have

occurred in district $11$ at locations with

a description of "CTA BUS STOP".

Show the case number, IUCR

primary description, IUCR

secondary description, date, and

community area number.

Order the result by secondary

description then primary

description.

Note: Only include crimes where

the "crime$\_$against" column equals

"Property".

$($D$)$

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

report showing each incident of

weapons violation.

Include crimes reported in

Chicago's "Central" side with a

primary description of "WEAPONS

VIOLATION".

Show the community area name,

secondary description, arrest, FBI

code, and ward columns.

Sort the results by secondary

description then by community

area name then by arrest.

$($D$)$ $$10$

$1\mathrm{.}8$ List the crimes reported to

have occurred at exactly $9$:$00$ am on

January $17,2018.$

Show the title from the FBI$\_$code

table, ward, district, case number,

and arrest.

Sort the results by district then by

title then by ward. $1\mathrm{.}8$ LIst the crimes reported to

have occurred at exactly $9$:$00$ am on

January $17,2018.$

Show the title from the FBI$\_$code

table, ward, district, case number,

and arrest.

Sort the results by district then by

title then by ward.

$($D$)$

$1\mathrm{.}9$ Suppose you work for

alderman Michele Smith in the office of

ward #$43.$ 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

#$43$ with an IUCR primary

description of "NARCOTICS".

Show the primary$\_$description,

secondary$\_$description, district,

arrest, case$\_$number, commander,

district phone number, FBI code,

and beat.

Sort the results by secondary

description then by district then by

arrest then by case$\_$number.

$($D$)$

$1\mathrm{.}10$ Suppose you live in the

Crestline 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$1\mathrm{.}10$ Suppose you live in the

Crestline 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 $($Crestline$)$ with

an IUCR primary description of

"WEAPONS VIOLATION".

Show the primary$\_$description,

secondary$\_$description, date,

location description, and beat.

Sort the results by secondary

description then by arrest then by

crime$\_$id$.$

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

$($D$)$

$1\mathrm{.}2$ List the crimes reported to

have occurred at schools in ward $6$

with a IUCR primary description of

"THEFT".

Show the secondary description,

district, case$\_$number, and block.

Crimes occurring at schools have a

location that starts with "school".

Sort the results by secondary

description then by district.

$($D$)$

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

primary description of "HOMICIDE" that

occurred in ward #$15$ where no arrest

has been made.

Show the primary description,

ward, district, date, and FBI code.

Sort the results by primary

description then by ward then by

district.

$1\mathrm{.}4$ List the crimes reported

between latitudes $41\mathrm{.}924$ and $41\mathrm{.}925$

$($inclusive$)$ that have a location

description of "WAREHOUSE".

Show the title from the FBI$\_$code

table, ward, district, case number,

and community area number.