-- Q1: Find all pizzerias who serve a pizza that no one eats.  Write this using a subquery and not the EXCEPT operator.
-- Put your SQL for Q1 below.  Be sure to leave a blank line below your answer.


-- Q2: Find names of people who don't frequent Pizza Hut
-- Put your SQL for Q2 below.  Be sure to leave a blank line below your answer.


-- Q3: Find the kind of the most expensive pizza and the pizzeria that serves it.  The result should be a pizzeria, pizza pair.
-- Put your SQL for Q3 below.  Be sure to leave a blank line below your answer.


-- Q4: Find pizzerias that are only frequented by females.
-- Put your SQL for Q4 below.  Be sure to leave a blank line below your answer.


-- Q5: For each served pizza, the number of individuals who eat that kind of pizza.  Your result should include pizzas that are served somewhere but eaten by no one -- for these pizzas, the number of individuals is zero.
-- Put your SQL for Q5 below.  Be sure to leave a blank line below your answer.


-- Q6: Find the average number of pizzas made by a pizzeria.  Hint: first do a subquery that computes the number of pizzas made by each pizzeria.
-- Put your SQL for Q6 below.  Be sure to leave a blank line below your answer.


-- Q7: Find the average number of pizza kinds eaten by each gender.
-- Put your SQL for Q7 below.  Be sure to leave a blank line below your answer.


-- Q8: Find the names of people who frequent at least three pizzerias that serve pizzas that they eat.  This is a challenging query.  The final answer should include the person named Hil (and in fact only Hil).  Hil frequents Dominos, Pizza Hut, and Straw Hut and each of those establishes serves at least one pizza that Hil eats (specifically, cheese, though Pizza Hut also serves supreme).
-- Put your SQL for Q8 below.  Be sure to leave a blank line below your answer.


-- Q9: Find names of pizzerias that serve pizzas that are eaten by people under 30 but not eaten by people over 30.
-- Put your SQL for Q9 below.  Be sure to leave a blank line below your answer.


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