For the below `store' schema:

product(productid,description,)

customer(customerid,username,fname,lname,street1,street2,city,state,zip)

purchase(purchaseid,purchasetimestamp,customerid,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 customer names who have never puchased anything.

5)List product descriptions who have never been purchased by anyone.

6)What products were purchased by customers with zip code 10001?

7)What percentage of customers have ever purchased productid=42?

8)Of customers who purchased productid=42, what percentage also purchased productid=24?

9) What is the most popular (purchased most often) product in NY state?

10)What is the most popular (purchased most often) product in North East?