1) List appeal information for each appeal that has a less than average number of crimes and aren't listed as violent offenders 2) Use a correlated subquery to determine which criminals have had at...

Oracle assignment attached



1) List appeal information for each appeal that has a less than average number of crimes and aren't listed as violent offenders 2) Use a correlated subquery to determine which criminals have had at least one probation period assigned. 3) Create a statement that always returns the names of the three criminals with the highest number of crimes committed. 4) create a view that includes details for all crimes, including criminal id, criminal name, criminal parole status, crime id, date of crime charge, crime status, charge id, crime code, charge status, pay due date, and amount due. this view shouldn't allow performing any DML operations. Each time the view is used in the application, the data should be queried from the database. (For example, each use of the view should reflect the most current data in the database.)