How have you used advanced Excel features to analyze and present data?
Demonstrate the SQL equivalent by producing a customer-level sales summary for completed sales from January through March 2025. Include customers without qualifying sales and classify each customer based on total sales.
customer_name, completed_order_count, total_sales, average_sale, and customer_tier.High for totals of at least 500, Standard for totals from 200 through 499.99, Starter for lower nonzero totals, and No purchases when no qualifying sale exists.total_sales descending, then customer_name ascending.| Column | Type | Description |
|---|---|---|
| customer_idPK | INT | Unique customer identifier |
| customer_name | VARCHAR(100) | Customer display name |
| region | VARCHAR(50) | Customer region |
| Column | Type | Description |
|---|---|---|
| sale_idPK | INT | Unique sale identifier |
| customer_id | INT | Customer associated with the sale |
| sale_date | DATE | Date of the sale |
| amount | DECIMAL(10,2) | Sale amount |
| status | VARCHAR(20) | Sale status |