Consider the following relational schema. An employee can work in more than one department; thepct_time field of the Works relation shows the percentage of time that a given employee works in a given department.

Emp(eid: integer, ename: string, age: integer, salary: real)

Works(eid: integer, did: integer, pct_time: integer)

Dept(did: integer, budget: real, managerid: integer)

2. Write the following queries in SQL and run them with MySQL. Print the sql statements and query results.

a) Find the names and salary of each employee who works in both the Sales Department and the Engineering department (assume that Sales Dept ID =101 0 and Engineering Dept ID = 201 2). Notice the correction on Dept ID above.

b) Find the department(s) with the highest average salary of employees.

c) Find the name and salary of each employee whose salary exceeds the budget of every department that he or she works in.