Restaurants with consistently high ratings

The partnerships team wants to feature restaurants that have enough order volume and a strong average rating. Some customers skip the rating prompt, so rating can be NULL.

From restaurant_orders, return restaurant_name, total_orders, rated_orders (orders that have a rating) and avg_rating (rounded to 2 decimals) for restaurants with at least 3 orders and an average rating of 4.2 or higher. Order by avg_rating descending, then restaurant_name.

1. Step 1: Conditions on aggregates such as `COUNT(*)` and `AVG(rating)` cannot go in `WHERE`; they belong in `HAVING`, which runs after grouping.
2. Step 2: `COUNT(*)` counts every order, while `COUNT(rating)` skips NULLs, which gives the number of rated orders.
3. Step 3: `AVG(rating)` also ignores NULLs, so Spice Route averages (5 + 4 + 5) / 3, not / 4.
4. Step 4: Tandoor Tales has a perfect average but only 2 orders, so the volume condition removes it.

SELECT restaurant_name,
       COUNT(*)                 AS total_orders,
       COUNT(rating)            AS rated_orders,
       ROUND(AVG(rating), 2)    AS avg_rating
FROM restaurant_orders
GROUP BY restaurant_name
HAVING COUNT(*) >= 3
   AND AVG(rating) >= 4.2
ORDER BY avg_rating DESC, restaurant_name;