Your question is Excel Live Assessment. Start with the requirements and the three tables 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.
Perform a live Excel assessment via screen share requiring creation of custom formulas, VLOOKUPs, and pivot tables.
Asked in the Technical Assessment stage. Live screen-share test during the interview process.
Write a PostgreSQL query that reproduces the same output as the Excel assessment using SQL only.
orders, customers, and products to enrich each order with customer segment and product category.customer_segment and product_category, with total revenue and order count.| Column | Type | Description |
|---|---|---|
| order_idPK | INT | Order identifier |
| customer_id | INT | Customer reference |
| product_id | INT | Product reference |
| order_date | DATE | Order date |
| order_status | VARCHAR(20) | Order status |
| quantity | INT | Units ordered |
| unit_price | DECIMAL(10,2) | Price per unit |
| Column | Type | Description |
|---|---|---|
| customer_idPK | INT | Customer identifier |
| customer_name | VARCHAR(100) | Customer name |
| customer_segment | VARCHAR(50) | Reporting segment |
| Column | Type | Description |
|---|---|---|
| product_idPK | INT | Product identifier |
| product_name | VARCHAR(100) | Product name |
| product_category | VARCHAR(50) | Reporting category |