table database is Cityjail_8.sql from Oracle 12c: SQL, 3rd Edition Joan Casteel ISBN: 978-1-30525103-8

The citys Crime Analysis unit has submitted the following data requests. Provide the SQL statements using sub queries to satisfy the requests. Test the statements and sure execution results all must work in oracle sql.

1. List appeal information for each appeal that has more than the average number of days between the filing and hearing dates

2. List each crime that has had the highest number of appeals recorded

3. List the information on crime charges for each charge that has had a fine below average and a sum paid above average

4. List the names of all criminals who have had any of the crime code charges involved in crime ID 10089

5. Use a correlated sub query to determine which criminals have had at least one probation period assigned

6. List the names of officers who have booked the highest number of crimes. Note that more than one officer might be listed