Wonderful! You've just found out there's only one pizza restaurant in Chicago that meets the criteria from the previous exercise. As you can see, there's not much choice, and obviously, Lisa is confused.
- Whhaat? This can't be true! We gotta keep searching, Gary... You know how much I don't like margheritas. At least, not margherita pizzas.
- I knew you were going to say this. Oh boo, so what do you suggest at this point?
- I've got an idea: let's check the average pizza prices of Chicago's restaurants and see if this helps.
Write a query that retrieves the names of restaurants in Chicago and their average pizza prices (as avg_price). Sort the results by the averages in descending order.
