SQL: Project Duration & Budget per Employee

Two SQL prompts: (1) names of employees who completed a project lasting more than 90 days; (2) average budget per employee per project, where each project's budget is split across its multiple employees. Schema not published; assume employees / projects plus a linking assignment table carrying start/end dates and a budget column. Problem Overview A Data Engineer technical screen built around SQL over an employee / project / budget schema. Two prompts: Return the names of employees who have completed a project that lasted more than 90 days. Return the average budget per employee per project. Each project has multiple employees and its budget is divided across them, so compute each employee's share and aggregate. Notes The exact table schema was not published. Expect an employees table, a projects table (with start/end dates and a budget column), and an assignment/membership table linking employees to projects. Duration filtering (DATEDIFF / date subtraction > 90) and per-project allocation (budget / COUNT(employees)) are the core skills; no window functions are strictly required. The same round also included a Python data-manipulation task, and the second technical round added a data-modeling / pipeline-design exercise.