Your question is Joining Tables in SQL. 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.
GlobalLogic's project delivery portal stores client, project, and time-entry data separately. Write a PostgreSQL query that produces a Q2 delivery summary for every active project with a valid client.
| Column | Type | Description |
|---|---|---|
| client_idPK | INT | Unique client identifier |
| client_name | VARCHAR(100) | Client organization name |
| region | VARCHAR(50) | Client operating region |
| Column | Type | Description |
|---|---|---|
| project_idPK | INT | Unique project identifier |
| client_id | INT | References clients.client_id |
| project_name | VARCHAR(150) | Project name |
| project_manager | VARCHAR(100) | Assigned project manager |
| status | VARCHAR(20) | Current project status |
| Column | Type | Description |
|---|---|---|
| entry_idPK | INT | Unique time-entry identifier |
| project_id | INT | References projects.project_id |
| consultant_id | INT | Consultant who logged the entry |
| consultant_name | VARCHAR(100) | Consultant display name |
| entry_date | DATE | Date the work was performed |
| billable_hours | NUMERIC(6,2) | Billable hours logged |