joining queeies $-$ these are the questions before $1\mathrm{.}6$ it will not let me post two pictures

$1\mathrm{.}6$ Build a detailed list of crimes against Society reported to have occurred in district $6$ at locations with a description of "GROCERY FOOD STORE".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.

$($D$)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 description 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.

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

Order the result by secondary description then primary description.

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

$($D$)10$

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

Include crimes reported in Chicago's "Far Southwest" side with a primary description of "STALKING".

Show the community area name, secondary description, arrest, district, and block columns.

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

$($D$)10$

$1\mathrm{.}8$ List the crimes reported to have occurred at exactly $8$:$00$ am on April $28,2018.$

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

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

$($D$)10$

$1\mathrm{.}9.$ Suppose you work for alderman Matthew O'Shea in the office of ward #$19.$ 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 #$19$ with an IUCR primary description of "NARCOTICS".

Shnus the nrimary decrintion cornndary docrintian dictrict arract$-$caca numbor