The following question will be based on City Jail database which is given 1.List all crime charges with a balance owed. List the charge ID, crime ID, fine amount, court fee, amount paid, and amount owed. Hint: Use this for formula (fine_amount+court_fee)-amount_paid "Owed" to find owed amount. Use Crime_charges table 2.List all criminals along with the crime charges filed. The report needs to include the criminal ID, name, crime code, and fine amount. Hint: Use Inner Join between criminals, crimes, crime_charges 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. Hint: Use Inner Join among criminals, crimes, crime_charges 4. Produce a list showing each active police officer and his or her community assignment, indicated by the second letter of the precinct code. Display the community description listed in the following chart, based on the second letter of the precinct code. Sample Output Second Letter of Precinct Code A 11 Description Shady Grove Center City Bay Land Q Hint: Use DECODE or CASE to find second column (Description) result. Description column name is a Alias and it will be custom made based on DECODE or CASE result Use this formular CASE (SUBSTR(precinct, 2,1), 'A' Or DECODE(SUBSTR(precinct, 2, 1), 'A',