Your question is SQL Join for Top Client Accounts. 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.
Write a query to join three tables to find the top-performing client accounts based on monthly utilization hours at Interactive Process Technology.
Return the top three ranks for each month from January and February 2025. Ties should share a rank and remain included.
utilization_month, account_name, monthly_utilization_hours, and monthly_rank| Column | Type | Description |
|---|---|---|
| account_idPK | INT | Unique client account identifier |
| account_name | VARCHAR(120) | Client account name |
| account_status | VARCHAR(20) | Current account status |
| Column | Type | Description |
|---|---|---|
| project_idPK | INT | Unique project identifier |
| account_id | INT | Client account associated with the project |
| project_name | VARCHAR(120) | Project name |
| project_status | VARCHAR(20) | Current project status |
| Column | Type | Description |
|---|---|---|
| utilization_idPK | INT | Unique utilization record identifier |
| project_id | INT | Project associated with the utilization record |
| utilization_date | DATE | Date on which hours were recorded |
| utilization_hours | DECIMAL(8,2) | Hours recorded for the project |