Problem
A. 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, 2023".
B. List the name of each officer who has reported longer than the average number of crimes officers have reported.
C. List the names of all criminals who have committed less than the average number of crimes and aren't listed as violent offenders.
D. List appeal information for each appeal that has longer than the average number of days between the filing and hearing dates.
E. List the names of probation officers who have had less than the average number of criminals assigned.
F. List each crime that has had the least number of appeals recorded.
G. List the following information for all crimes that have a period longer than 10 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.