Your question is SQL Fundamentals. Start with the requirements and the one table on the right.
Run and submit as often as you like. When you're ready, talk me through your approach or go straight to the code.
What is your experience with SQL?
To demonstrate your SQL experience, write a query using the provided orders table. Include only completed orders with a known customer name, then summarize the results by customer.
customer_name, completed_order_count, and total_completed_amount.| Column | Type | Description |
|---|---|---|
| order_idPK | INT | Unique order identifier |
| customer_name | VARCHAR(100) | Customer name associated with the order |
| status | VARCHAR(20) | Current order status |
| order_amount | DECIMAL(10,2) | Order amount in dollars |
| order_date | DATE | Date the order was placed |