Join Queries Assessment

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 in vehicles in ward $14$ with a IUCR primary description of "CRIMINAL DAMAGE".

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

Crimes occurring in vehicles have a location that starts with "vehicle".

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

$10$

$1\mathrm{.}3$List the crimes reported with a primary description of "OFFENSE INVOLVING CHILDREN" that occurred in ward #$39$ where no arrest has been made.

Show the primary description, ward number, district number, case$\_$number, community area number, and beat.

Sort the results by district number then by primary description then by ward number then by case$\_$number.