Back to problems

Project Duration & Budget per Employee

SQL · Snowflake · Medium

Problem Overview You are given a SQL exercise based on an employee, project, and budget data model. Write queries for both tasks below: List the names of employees who worked on at least one project whose duration exceeded 90 days. Calculate the average budget assigned to one employee on one project. A project's total budget must be divided evenly among all employees assigned to it, and those per-employee amounts must then be averaged. Assume the following tables and…

Checking your access…