-- Q1: Find pizzeria, pizza pairs such that both Amy and Fay eat that kind of pizza and the pizzeria serves this kind of pizza for less than $10.
-- Put your SQL for Q1 below.  Be sure to leave a blank line below your answer.


-- Q2: Find all pizzas that no one eats.
-- Put your SQL for Q2 below.  Be sure to leave a blank line below your answer.


-- Q3: Find the names of all people who eat at least one pizza served by Dominos but who do not frequent Dominos.  You may assume, for this question, that the name is a key for the Person table (thus, no two people have the same name).
-- Put your SQL for Q3 below.  Be sure to leave a blank line below your answer.


-- Q4: Find names of people who eat both cheese and sausage pizza.
-- Put your SQL for Q4 below.  Be sure to leave a blank line below your answer.


-- Q5: Straw Hat is having a sale of 10% off all pizzas.  Write a query that returns the Serves relation except with Straw Hat's prices updated to reflect the sale.
-- Put your SQL for Q5 below.  Be sure to leave a blank line below your answer.


-- Q6: Find the price of the most expensive pizza served by Pizza Hut. Name the result highestPrice.
-- Put your SQL for Q6 below.  Be sure to leave a blank line below your answer.


-- Q7: Find the age of the oldest person (or people) who eat mushroom pizza.  Name the result oldest.
-- Put your SQL for Q7 below.  Be sure to leave a blank line below your answer.


-- Q8: Find the price of the most expensive pizza served by each pizzeria.  Name the maximum price field as maxPrice.
-- Put your SQL for Q8 below.  Be sure to leave a blank line below your answer.


-- Q9: Find the number of pizzas made by each pizzeria.  Name the count field as pizzaCount.
-- Put your SQL for Q9 below.  Be sure to leave a blank line below your answer.


-- Q10: Find the number of distinct kinds of pizza eaten by each gender.  Name the count field as pizzaCount.
-- Put your SQL for Q10 below.  Be sure to leave a blank line below your answer.


-- Q11: Find the names of pizzerias who serves at least 4 kinds of pizza.
-- Put your SQL for Q11 below.  Be sure to leave a blank line below your answer.


-- Q12: Find the names of pizzerias who are frequented by at least two different women.
-- Put your SQL for Q12 below.  Be sure to leave a blank line below your answer.


-- Q13: Find the average age of females who eat cheese pizza.  Name the result averageAge.
-- Put your SQL for Q13 below.  Be sure to leave a blank line below your answer.


-- End of file. Do not delete this line.
