What is your familiarity with SQL? Tell me about yourself and some of your projects.
Using the supplied project and task tables, demonstrate your SQL experience by producing a concise project-level summary.
project_id, project_name, completed_task_count, total_task_hours, and latest_completion_date.project_id ascending.| Column | Type | Description |
|---|---|---|
| project_idPK | INT | Unique project identifier |
| project_name | VARCHAR(100) | Project name |
| project_status | VARCHAR(30) | Current project status |
| Column | Type | Description |
|---|---|---|
| task_idPK | INT | Unique task identifier |
| project_id | INT | Project associated with the task |
| task_name | VARCHAR(120) | Task name |
| task_status | VARCHAR(30) | Current task status |
| hours | DECIMAL(8,2) | Hours recorded for the task |
| completed_date | DATE | Date the task was completed |