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 |