Write SQL queries that will answer the following questions, using the data in the PetStore database. Please write your queries using your favorite text editor (copying them into DB Browser to execute them, as we have done in class), with all queries in a single file, named Assignment4.sql. Include a comment before each query stating the question number of the question it answers. When you are finished, upload the SQL file here to Canvas. You may find it helpful to have the PetStore relationships diagram open as you work on this assignment.
(4 points) List the item ID, description, and quantity on hand for all merchandise items that the pet store has at least 50 copies of on hand.
(4 points) List the animal ID, category, and birth date of all animals that were born between April 1, 2004 and June 30, 2004.
(4 points) List the sale ID, customer ID, and sale date of all sales transacted in November of 2004.
(5 points) List the animal ID, category, breed, birth date, and list price of all animals that were born before March 1, 2004, or have a list price of at least $250.
(4 points) List the animal ID, category, and breed of all animals for which the breed starts with the letter ‘D’.
(5 points) List the animal ID, category, breed, and breed registration (field Registered) of all animals that have a registered breed (i.e., the breed registration is not NULL).