This database contains data about crimes reported in the city of Chicago during 2018.
List the crimes reported with an IUCR NUMBER of "1478" that occurred in ward NUMBER 23 where an arrest has been made.
a. Show the date, case number, district number, and ward number.
b. Sort the results by date then by case number.
District
district_no
district_name
address
zip_code
commander
email
phone
fax
tty
twitter
Crime
report_no
case_number
date
block
iucr_no
location_description
arrest
domestic
beat
district_no
ward_no
fbi_code_no
community_area_no
latitude
longitude
location
IUCR
iucr_no
primary_description
secondary_description
index_code
FBI_Code
fbi_code_no
title
description
crime_against
Ward
ward_no
alderman_first_name
alderman_last_name
alderman_name_suffix
ward_office_address
ward_office_zip
ward_email
ward_office_phone
ward_office_fax
city_hall_office_room
city_hall_office_phone
city_hall_office_fax
population
Community_Area
community_area_no
community_area_name
side
population
Neighborhood
neighborhood_name
community_area_no