Your question is Project Volume Change Query. 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.
Find the cost_center_id, project_name, and the highest avg increase volume in project from yesterday to today.
Asked in the Phone Screen stage. SQL question on project and cost center data comparing volume changes from yesterday to today.
cost_center_id, project_name, and highest_avg_increase_volumehighest_avg_increase_volume descending, then cost_center_id, then project_name| Column | Type | Description |
|---|---|---|
| volume_idPK | BIGINT | Unique row identifier |
| cost_center_id | INT | Cost center identifier |
| project_name | VARCHAR(255) | Project name |
| volume_date | DATE | Date of the volume measurement |
| volume | NUMERIC(12,2) | Measured volume for the project on that date |