Queries with Restrictions Assessment

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

1.6 List the crimes reported in district #9 where no location description has been reported. a. Show the date, case number, ward number, and block. b. Sort the results by case number then by date.

1.7 List the crimes reported in district #7 with an IUCR number of 2023 along with those reported in ward #48 with an FBI code number of 15. a. Show the case number, FBI code number, ward number, IUCR number, district number, date, and block. b. Sort the results by FBI code number then by ward number then by IUCR number then by district number then by case number.

1.8 List the crimes reported between latitudes 41.95 and 41.951 (inclusive) that have a location description of "SIDEWALK". a. Show the date, case number, block, and FBI code. b. Sort the results by date then by case number.

1.9 Which wards had at least one crime with an IUCR number of "1360" (CRIMINAL TRESPASS) reported at a location with a description of "SIDEWALK"? a. Show only the ward number in ascending order. b. Be sure your result does not include any duplicates.

1.10 List the location descriptions where crimes with an IUCR number of "2826" (OTHER OFFENSE) have occurred in ward #47. a. Show only the location_description in alphabetical order. Be sure your result does not include any duplicates

\\begin{tabular}{|l|l} \\hline \\multicolumn{1}{|c}{ District } \\\\ \\hline district_no or \\\\ \\hline district_name \\\\ \\hline address \\\\ \\hline zip_code \\\\ \\hline commander \\\\ \\hline email \\\\ \\hline phone \\\\ \\hline fax \\\\ \\hline tty \\\\ \\hline twitter \\\\ \\hline FBI_Code \\\\ \\hline fbi_code_no o- \\\\ \\hline title \\\\ \\hline description \\\\ \\hline crime_against \\\\ \\hline Community_Area \\\\ \\hline community_area_no or \\\\ \\hline community_area_name \\\\ \\hline side \\\\ \\hline population \\\\ \\hline \\end{tabular} \\begin{tabular}{|l|} \\hline \\multicolumn{1}{|c}{ Crime } \\\\ \\hline report_no \\\\ \\hline case_number \\\\ \\hline date \\\\ \\hline block \\\\ \\hline iucr_no \\\\ \\hline location_description \\\\ \\hline arrest \\\\ \\hline domestic \\\\ \\hline beat \\\\ \\hline district_no \\\\ \\hline ward_no \\\\ \\hline fbi_code_no \\\\ \\hline community_area_no \\\\ \\hline latitude \\\\ \\hline longitude \\\\ \\hline location \\\\ \\hline \\end{tabular} Neighborhood neighborhood_name on community_area_no