this problem from oracle 12c chapter 9 and honestly i don't have a book so please, i need to be done by this week, i don't have book with me and this all in so i try to put some query from chapter 8,

QUERY FROM CHAPTER 8.SQL*/ select * from aliases ; select * from criminals ; select * from crimes ; select * from appeals ; select * from officers ; select * from crime_officers ; select * from crime_charges ; select * from crime_codes ; select * from prob_officers ; select * from sentences ;

nse Study: City Jail oter: Use the C satements that satisfy hapter 8 case study The following list City Jail database created with the City Jail 8.sql script that you ran for the f the requests. For each request, include one solution using the traditional using an ANSI JOIN statement. Test the statements and show execution dflects the current data requests from city managers. Provide the sQL th with the crime charges filed. The report needs to include the criminal D, name, crime code, and fine amount. l criminals along with crime status and appeal status (if applicable). The reports need ude the cminal ID, name, crime classification, date charged, appeal filing date, and speal status. Show all criminals, regardless of whether they have fled an appeal. 3 List all criminals along with crime information. The report needs to include the criminal ID, name, crime classification, date charged, crime code, and fine amount. Include only crimes classified as "Other." Sort the list by criminal ID and date charged. 4 Create an alphabetical list of all criminals, including criminal ID, name, violent offender status, parole status, and any known aliases. S. A table named Prob_Contact contains the required frequency of contact with a probation fier, based on the length of the probation period (the number of days assigned to Joining Data from Multiple probation). Review the data in this table, which indicates ranges for the number of days applicable contact frequencies. Create a list containing the name of each criminal who h been assigned a probation period, which is indicated by the sentence type. The list should contain the criminal name, probation start date, probation end date, and required fr of contact. Sort the list by criminal name and probation start date. equency 6. A column named Mgr JD has been added to the Prob Officers table and contains the ID number of the probation supervisor for each officer. Produce a list showing each probation officer's name and his or her supervisor's name. Sort the list alphabetically by probation officer name