[Solved]Write Following Queries Sql Employee Ename Salary Project Pname Agency Budget Assign Pname Q37184719

write the following queries in SQL.

Employee(Ename, Salary)

Project(Pname,Agency,Budget)

Assign(Pname,Ename).

1) For every project, compute the number of projects whosebudget is higher

2): Find the projects with the budget lower than the averageproject budget at the same agency

Expert Answer

---

Answer to write the following queries in SQL. Employee(Ename, Salary) Project(Pname,Agency,Budget) Assign(Pname,Ename). 1) For eve… . . .