Question: 1 . 8 List the crimes reported between latitudes 4 1 . 8 8 and 4 1 . 8 8 1 ( inclusive ) that

1.8 List the crimes reported
between latitudes 41.88 and 41.881
(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.
()110
1.9 Which wards had at least one
crime with an IUCR number of "1305"
(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.
1.10 List the location descriptions
where crimes with an IUCR number of
"1130"(DECEPTIVE PRACTICE) have
occurred in ward #19.
Show only the location_description
in alphabetical order.
Be sure your result does not
include any duplicates.
1 . 8 List the crimes reported between latitudes

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Programming Questions!