Resolve the question below in Excel. For this SQL version, use the supplied customers and orders data to return a summary for every active customer based on completed orders with non-null amounts.
Output
- One row per active customer, including customers without qualifying orders.
- Columns:
customer_name, region, completed_order_count, total_completed_sales, and spending_band.
- Sort by total sales descending, then customer name ascending.
Output details
- Assign
High when total sales are at least 1000, Medium when at least 500 but below 1000, and Low otherwise.
- Represent customers without qualifying orders with
completed_order_count 0, total_completed_sales 0, and spending_band Low.