i been asking some programing but previous program actually wasnt follow the book so anyone plz make sure that follows the book so it is oracle 12c SQL by joan casteel its due tomorrow

Case Study: City Jail 8.sql file provided by your instructor to ensure that all necessary Note: Run rstraints are available for this case study. This script isn't included in the CityJail 8.sql file provided b ables anat files because case study assignments in previous chapters include table studenchallenges. This script rebuilds the City Jail database. Don't be concerned with ables and con data files beca the DROP TABLE commands, which delete any existing tables of the same names wing list reflects common data requests from city managers. Write the ents to satisfy the requests. If the query can be accomplished by using The follo sQL statem diferent test them a execution results. 1. List all criminal aliases beginning with the letter B. operators, supply alternative solutions so that the performance-tuning group can nd identify the more efficient statements. Test the statements and show 2 List all crimes that occurred (were charged) during the month October 2008. List the crime ID, criminal ID, date charged, and classification. 3. List all crimes with a status of CA (can appeal) or IA (in appeal). List the crime ID, criminal ID, date charged, and status. 4. List all crimes classified as a felony. List the crime ID, criminal ID, date charged, and classification 5 List all crimes with a hearing date more than 14 days after the date charged. List the crime ID, criminal ID, date charged, and hearing date. istall ciminals with the zip code 23510. List the criminal ID, last name, and zip code. Sort the list by criminal ID 7. List all crimes that don't have a hearing date scheduled. List the crime ID, criminal ID, date a heari charged, and hearing date. 8 List all sentences es with a probation officer assianed. List the sentence ID, criminal ID, and er ID. Sort the list by probation officer ID and then criminal ID. Restricting Rows and Sorting Data