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 |