Multi-Step CTE Pipeline

Write a query using multiple CTEs: first compute average order value per customer, then classify customers as 'High' (avg > 200), 'Medium' (avg > 100), or 'Low'. Return customer_name, avg_order_value (rounded to 2 decimals), and tier, ordered by avg_order_value DESC.

Expected Output: Customers classified into spending tiers.