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, 2023 [2 marks]

2. List the name of each officer who has reported longer than the average number of crimes officers have reported [2 marks]

3. List the names of all criminals who have committed less than average number of crimes and arent listed as violent offenders [2 marks]

4. List appeal information for each appeal that has longer than the average number of days between the filing and hearing dates [2 marks]

5. List the names of probation officers who have had less than average number of criminals assigned [2 marks]

6. List each crime that has had the least number of appeals recorded [2 marks]

7. 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 [2 marks]