This database contains data about crimes reported in the city of Chicago during $2018.$

$1\mathrm{.}1$Make a community$-$area neighborhood list.

Show the side, community area name, and the name of the neighborhood.

Sort the results by side then by community area name then by neighborhood

$10$

$1\mathrm{.}2$List the crimes reported to have occurred at schools in ward $49$ with a IUCR primary description of "BATTERY".

Show the secondary description, district number, case number, and location description.

Crimes occurring at schools have a location that starts with "school".

Sort the results by secondary description then by district number then by case number.