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

North Mayfair 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

$($North Mayfair$)$ with an IUCR

primary description of

"NARCOTICS".

Show the

primary$\_$description,

secondary$\_$description,

arrest, report number, date,

location description, and

beat.

Sort the results by arrest

then by secondary

description then by report

number.