20 sql questions for running case study city jail | SQL

Hello all, I need 20 SQL questions along with the code to answer the question. An example would be:

“List all criminals with the zipcode: 23320.”

SELECT criminal_ID, last, zip

FROM criminals

WHERE zip = 23320;

To help with the question design I have attached the case study’s ER diagram.

"Get 15% discount on your first 3 orders with us"
Use the following coupon
"FIRST15"

Order Now