DoorDash is running a pizza promotion in New York and Chicago and wants to feature the best-rated spots.
List restaurants in New York or Chicago whose name contains "pizza" in any capitalisation and that have a rating.
Expected output
Return: restaurant id, name, city and rating (name the columns however you like)
name, then by restaurant_idExample of the shape (made-up values):
| restaurant_id | name | city | rating |
|---|---|---|---|
| 3 | Bella Pizzeria | Chicago | 4.9 |
Write your query here. Ctrl + Enter submits.