20 SQL Questions For Running Case Study City Jail

I need 20 SQL questions along with the code to answer the question. An example would be:

“List all criminals with the zipcode: 23320.”

SELECT criminal_ID, last, zip

FROM criminals

WHERE zip = 23320;

To help with the question design I have attached the case study’s ER diagram.

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

Email

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

You don't know how to answer this question. We can help you find the right answer.

We assure you an A+ quality paper that is free from plagiarism. Order now for an Amazing Discount! Use Discount Code "save15" for a 15% Discount!

Get Started

No need to wonder who can do my homework. You can always reach our team of professionals to do your homework at a low price.