20 SQL Questions for Running Case Study City Jail

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.