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.

0 replies

Leave a Reply

Want to join the discussion?
Feel free to contribute!

Leave a Reply

Your email address will not be published. Required fields are marked *