-- Q1: Find pizzerias that serve pepperoni or cheese pizza, ordered by price from least expensive to most expensive.  The result should include the name of the pizzeria, the kind of pizza, and the price.
-- Put your SQL for Q1 below.  Be sure to leave a blank line below your answer.


-- Q2: Straw Hat is having a sale of 10% off all pizzas.  Write a query that returns a list of Straw Hat's pizzas and their prices, with the prices updated to reflect the sale.  Name the updated price column "saleprice."
-- Put your SQL for Q2 below.  Be sure to leave a blank line below your answer.


-- Q3: Find pizzerias that have the word Pizza in their name.  Each name should appear only once.
-- Put your SQL for Q3 below.  Be sure to leave a blank line below your answer.


-- Q4: Find the name of the most expensive pizza.  Your query should return a table with a single row and a column that contains the name of the most expensive pizza served.
-- Put your SQL for Q4 below.  Be sure to leave a blank line below your answer.


-- Q5: Find the names of pizzerias that serve pizzas that cost under $9 and are either pepperoni or cheese.  The result should include only the name of the pizzeria and duplicate names should be eliminated.
-- Put your SQL for Q5 below.  Be sure to leave a blank line below your answer.


-- Q6: Find the names of males who frequent Pizza Hut.
-- Put your SQL for Q6 below.  Be sure to leave a blank line below your answer.


-- Q7: Are there pizzerias that serve pizzas that Dan likes to eat for under $8?  Write a query that returns the pizza, the pizzeria where it's served, and the price of the pizza at that pizzeria.  (Note: Dan may not necessarily frequent this pizzeria.)
-- Put your SQL for Q7 below.  Be sure to leave a blank line below your answer.


-- Q8: Names of people together with the pizzas they like to eat along with where they like to eat it.
-- Put your SQL for Q8 below.  Be sure to leave a blank line below your answer.


-- Q9: Find the names of all females who eat at least one pizza served by Straw Hat. (Note: The pizza need not be eaten at Straw Hat.)
-- Put your SQL for Q9 below.  Be sure to leave a blank line below your answer.


-- Q10: Find pairs of pizzerias who sell the same kind of pizza for the same price.  The result should include both the names of both pizzerias along with the pizza and the price.
-- Put your SQL for Q10 below.  Be sure to leave a blank line below your answer.


-- Q11: Find all pizzas either Amy or Fay (or both) eat.
-- Put your SQL for Q11 below.  Be sure to leave a blank line below your answer.


-- Q12: Find all pizzas that both Amy and Fay eat.  Hint: this is harder than it looks.
-- Put your SQL for Q12 below.  Be sure to leave a blank line below your answer.


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