90 minute online exam on codesignal before talking to a recruiter. Coding was ridiculously easy, SQL questions slightly harder, and they had some really silly data science multiple choice questions which involved hand calculating the results of linear and logistic regression.
For the SQL portion, write a query using the provided customers and orders tables. Return customers with at least two completed orders.
customer_name, completed_order_count, and total_completed_amount.total_completed_amount descending, then customer_id ascending to break ties.| Column | Type | Description |
|---|---|---|
| customer_idPK | INT | Unique customer identifier |
| customer_name | VARCHAR(100) | Customer display name |
| Column | Type | Description |
|---|---|---|
| order_idPK | INT | Unique order identifier |
| customer_id | INT | Customer associated with the order |
| status | VARCHAR(20) | Current order status |
| order_amount | NUMERIC(10,2) | Order amount |