Note: Run the CityJail$\_8.$sql file provided by your instructor to ensure that all necessary tables and constraints are available for this case study. This script isn't included in student data files because case study assignments in previous chapters include table creation challenges. This script rebuilds the City Jail database. Don't be concerned with errors from the DROP TABLE commands, which delete any existing tables of the same names.

The following list reflects common data requests from city managers. Write the SQL statements to satisfy the requests. If the query can be accomplished by using different operators, supply alternative solutions so that the performance$-$tuning group can test them and identify the more efficient statements. Test the statements and show execution results.

List all criminal aliases beginning with the letter $B.$

List all crimes that occurred $($were charged$)$ during the month October $2008.$ List the crime ID$,$ criminal ID$,$ date charged, and classification.

List all crimes with a status of CA $($can appeal$)$ or IA $($in appeal$).$ List the crime ID$,$ criminal ID$,$ date charged, and status.

List all crimes classified as a felony. List the crime ID$,$ criminal ID$,$ date charged, and classification.