How would you write SQL queries and relate them to an object-oriented design for a project-based requirement?
Use the projects, tasks, and employees tables. Return every project, including projects without tasks or an assigned owner, with the requested aggregate information.
Output
- One row per project with
project_code, project_name, owner_name, total_tasks, completed_tasks, total_estimated_hours, completion_percentage, and project_status
- Include all projects, label missing owners as
Unassigned, and sort by project_code ascending