Atlas $3\mathrm{.}0$

$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

$($D$)10$

$1\mathrm{.}2$ List the crimes reported to have occurred at residences in ward $3$ with a IUCR primary description of "MOTOR VEHICLE THEFT".

Show the secondary description, district, case$\_$number, and beat.

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

Sort the results by secondary description then by district.

$()10$

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

VIOLATION" that occurred in ward #$44$ where an arrest has been made.

Show the primary description, ward, district, location description, and FBI code.

Sort the results by district then by primary description then by ward.

$($D$)10$

$1\mathrm{.}4$ List the crimes reported between latitudes $41\mathrm{.}961$ and $41\mathrm{.}962($inclusive$)$ that have a location descriptior of "SIDEWALK".

Show the title from th$$ FBI$\_$code table, ward, district, beat, and block.

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

$($D$)10$

$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 $40$ where no arrest has been made.

Show the case number, IUCR primary description, IUCR secondary description, date, and district number.