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

with a primary description of

"PROSTITUTION" that occurred

in ward #$17$ where an arrest has

been made.

Show the primary

description, ward number,

district number,

case$\_$number, FBI code

number, and location

description.

Sort the results by district

number then by ward

number then by primary

description then by

case$\_$number.

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

between latitudes $41\mathrm{.}886$ and

$41\mathrm{.}887($inclusive$)$ that have a

location description of

"WAREHOUSE".

Show the title from the

FBI$\_$code table, ward

number, district number,

report$\_$number, arrest, and

block.

Sort the results by ward

number then by title then by

district number then by

report number. $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 $20$ where an

arrest has been made.

Show the case number,

Iocation description, IUCR

primary description, district

number, and IUCR secondary

description.

Order the result by

secondary description then

primary description then by

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 #$6$ at

locations with a description of

"CONVENIENCE STORE".

Show the case number, IUCR

primary description, IUCR

secondary description, beat,

and ward number.

Order the result by primary

description then secondary

description then by case

number.

Note: Only include crimes

where the "crime$\_$aqainst" $1\mathrm{.}7$ Build a community$-$area

crime report showing each

incident of liquor law violation.

Include crimes reported in

Chicago's side named

"Central" with a primary

description of "LIQUOR LAW

VIOLATION".

Show the community area

name, secondary

description, arrest,

report$\_$number, location

description, and

case$\_$number columns.

Sort the results by

community area name then

by arrest then by secondary

description then by report

number.

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

to have occurred at exactly $10$:$00$

am on July $7,2018.$

Show the title from the

FBI$\_$code table, ward

number, district number,

report number, arrest, and

FBI code.

Sort the results by title

number then by district then

by ward number then by

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

alderman Raymond Lopez in the

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

primary description of

"INTERFERENCE WITH

PUBLIC OFFICER".

Show the

primary$\_$description,

secondary$\_$description,

district number, arrest,

case$\_$number, commander,

district phone number,

community area number, and

location description.

Sort the results by district

number then by arrest then

by secondary description

then by case$\_$number.

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 $18$ with a IUCR primary

description of "SEX OFFENSE".

Show the secondary

description, district number,

case number, and date.

Crimes occurring at

residences have a location

that starts with "residen".

Sort the results by district

number then by secondary

description then by case

number.