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.