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…