Question: 1 . 8 List the crimes reported between latitudes 4 1 . 8 8 and 4 1 . 8 8 1 ( inclusive ) that
List the crimes reported
between latitudes and
inclusive that have a location
description of "ATHLETIC CLUB".
Show the date, case number, FBI
code, and ward number.
Sort the results by case number
then by date.
Which wards had at least one
crime with an IUCR number of
CRIMINAL DAMAGE reported at a
location with a description of
"RESTAURANT"?
Show only the ward number in
ascending order.
Be sure your result does not
include any duplicates.
List the location descriptions
where crimes with an IUCR number of
DECEPTIVE PRACTICE have
occurred in ward #
Show only the locationdescription
in alphabetical order.
Be sure your result does not
include any duplicates.
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
