CISC 7510X (DB1) Homeworks

You should EMAIL me homeworks, alex at theparticle dot com. Start email subject with "CISC 7510X HW#". Homeworks without the subject line risk being deleted and not counted.

CISC 7510X HW# 1 (due by 3rd class;): For the below `store' schema:
product(productid,description,listprice)
customer(customerid,username,fname,lname,street1,street2,city,state,zip)
purchase(purchaseid,purchasetimestamp,customerid)
purchase_items(itemid,purchaseid,productid,quantity,price)

Using SQL, answer these questions (write a SQL query that answers these questions):

1. What is the description of productid=42?
2. What's the name and address of customerid=42?
3. What products did customerid=42 purchase?
4. List customers who bought productid=24?
5. List customer names who have never puchased anything.
6. List product descriptions who have never been purchased by anyone.
7. What products were purchased by customers with zip code 10001?
8. What percentage of customers have ever purchased productid=42?
9. Of customers who purchased productid=42, what percentage also purchased productid=24?
10. What is the most popular (purchased most often) product in NY state?
11. What is the most popular (purchased most often) product in Tri-state Area? (NJ, NY, CT)
12. Who purchased productid=24 prior to July 4th, 2020?
13. For each customer, find all products from their last purchase.
14. For each customer, find all products from their last 10 purchases.
15. Names of customers who have purchased product 42 in the last 3 months.

Also, install PostgreSQL.