Can you explain a time you used Python or SQL to solve a complex business problem?
For this hands-on version, use the provided customer and order data to demonstrate a SQL-based business analysis. Return customers with at least two completed orders and at least 500 in completed order value.
customer_id, customer_name, completed_order_count, completed_order_value| Column | Type | Description |
|---|---|---|
| customer_idPK | INT | Unique customer identifier |
| customer_name | VARCHAR(100) | Customer display name |
| customer_region | VARCHAR(50) | Customer region |
| Column | Type | Description |
|---|---|---|
| order_idPK | INT | Unique order identifier |
| customer_id | INT | Customer associated with the order |
| order_status | VARCHAR(20) | Order lifecycle status |
| order_amount | DECIMAL(10,2) | Monetary value of the order |
| sales_channel | VARCHAR(30) | Channel where the order was placed |