Problem 1 (10 pts) You are given the following relational schema (keys underlined): Employee (Ename,Salary) Project (Pname, Agency, Budget) Assign (Pname,Ename) Foreign keys: Ename in Assign references Employee (Ename) Pname in Assign references Project (Pname) Write the following queries in SQL S: Find the employees assigned to exactly one project. .S2: Find the employees whose salary is greater than Mark’s salary (Mark is an employee). S3: For every project, compute the number of projects whose budget is higher S4:
OR
OR