They are Corrent I got an A for this Assignment
-
List the name of each officer who has reported more than the average number of crimes officers have reported.
-
List the names of all criminals who have committed less than average number of crimes and aren’t listed as violent offenders.
-
List appeal information for each appeal that has a less than average number of days between the filing and hearing dates.
-
List the names of probation officers who have had a less than average number of criminals assigned.
-
List each crime that has had the highest number of appeals recorded.