1. Produce a list of sentencing information to include criminal ID,…

/in /by

Question Answered step-by-step 1. Produce a list of sentencing information to include criminal ID,… Image transcription textori mes crime_charges ori me_codes City Jail Database ERD P P crime_id NUMBER (9) P charge_id NUMBER(10) crime_code NUMBER (3) criminal_id NUMBER (8) F crime_id NUMBER () code_description VARCHAR2(30) classification CHAR (1) crime_code NUMBER () 2 crimecodes_code_pk (crime_code) date_ch… Show more… Show more 1. Produce a list of sentencing information to include criminal ID, full name, sentence ID, sentence start date, and the length in months of the sentence. The number of months should be shown as a whole number. That start date should be displayed in the format “January 1, 2022” 2. List the name of each officer who has reported less than the average number of crimes officers have reported 3. List the names of all criminals who have committed more than average number of crimes and aren’t listed as violent offenders 4. List appeal information for each appeal that has a less than the average number of days between the filing and hearing dates 5. List the names of probation officers who have had a greater than average number of criminals assigned  6. List each crime that has had the least number of appeals recorded 7. List the following information for all crimes that have a period greater than 14 days between the data charged and the hearing date: crime ID, classification, date charged, hearing date, and the number of days between the date charged and the hearing date   Computer Science Engineering & Technology MYSQL Share QuestionEmailCopy link Comments (0)

Needs help with similar assignment?

We are available 24x7 to deliver the best services and assignment ready within 3-4 hours? Order a custom-written, plagiarism-free paper

Get Answer Over WhatsApp Order Paper Now