20 SQL Questions for Running Case Study City Jail
Aliases
Sentence_id
Criminal_id
Type
Prob_id
Start_date
End_date
Violations
Alias_id
Criminal_id
Alias
City Jail Database ERD
Prob_id
Last
First
Street
City
State
Zip
Phone
Status
Prob_Officers
Crime_code
Code_description
Crime_codes
Charge_id
Crime_id
Crime_code
Charge_status
Fine_amount
Court_fee
Amount_paid
Pay_due_date
Crime_charges
Crime_officers
Crime_id
Officer_id
Officers
Officer_id
Last
First
Precinct
Badge
Phone
Status
Appeal_id
Crime_id
Filing_date
Hearing_date
Status
Appeals
Crimes
Crime_id
Criminal_id
Classification
Date_charged
Status
Hearing_date
Appeal_cut_date
Criminals
Criminal_id
Last
First
Street
City
State
Zip
Phone
V_status
P_status
Sentences