CustomeTextbook Orcale 120 506 Case Study: City Jail Note: Use the City Jail database created with the City Jail_8 sql script that you ran for the Chapter 8 case study Tre following list reflects the current data requests from city managers. Provide the SQL statements that satisfy the requests. For each request, include one solution using the aditional method and one using an ANS! JOIN statement. Test the statements and show execution results 1. Lista criminals along with the crime charges fred. The report needs to Indiade the criminal name crime code, and fine amount 2. Liut al camins along with one statius and appeal status of applicable). The reports need to include the criminal 10, name, crime classication date charged appealing dato, and appeal status Show all criminals, regardless of whether they have med an appeal 3 List al criminal song with crime information. The report needs to include the criminal D, name, crme classification date charged crime code and fine amount include only crimes clasified as Othet Sort by criminal and date changed Create an ahalist of all intencluding a name vient onder status parole status and any known ases Stare Pro Contact contain the record frequency of contact with a probationchic based on the length in ration period member of daytired to probation Review the dotatabehind ranges for the number of days and applicable contact requencies Create a list contain the name of each who has been assigned a grobation Deriod which is indicated by the tipe that should contain the camera stata rind date and required frequency of contact Sort me by crime and toplam named good to me Prisoners totie and content to hunter at the probation supervisor for an officer Ridducat ingeschret 50 ser ser name on melancay by birge Micercare a W CustomeTextbook Orcale 120 506 Case Study: City Jail Note: Use the City Jail database created with the City Jail_8 sql script that you ran for the Chapter 8 case study Tre following list reflects the current data requests from city managers. Provide the SQL statements that satisfy the requests. For each request, include one solution using the aditional method and one using an ANS! JOIN statement. Test the statements and show execution results 1. Lista criminals along with the crime charges fred. The report needs to Indiade the criminal name crime code, and fine amount 2. Liut al camins along with one statius and appeal status of applicable). The reports need to include the criminal 10, name, crime classication date charged appealing dato, and appeal status Show all criminals, regardless of whether they have med an appeal 3 List al criminal song with crime information. The report needs to include the criminal D, name, crme classification date charged crime code and fine amount include only crimes clasified as Othet Sort by criminal and date changed Create an ahalist of all intencluding a name vient onder status parole status and any known ases Stare Pro Contact contain the record frequency of contact with a probationchic based on the length in ration period member of daytired to probation Review the dotatabehind ranges for the number of days and applicable contact requencies Create a list contain the name of each who has been assigned a grobation Deriod which is indicated by the tipe that should contain the camera stata rind date and required frequency of contact Sort me by crime and toplam named good to me Prisoners totie and content to hunter at the probation supervisor for an officer Ridducat ingeschret 50 ser ser name on melancay by birge Micercare a W
