Consider the following relations. An employee can work in more than one department; the pct 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, dname: string, budget: real, managerid: integer)

Write and execute the following queries in SQL:

1. Print the names and ages of each employee who works in the Hardware department.

2. For each department with more than 20 employees, print the did together with the number of employees that work in that department.

3. Print the name of each employee whose salary exceeds the average salary of all employees.

4. Find the managerids of managers who manage only departments with budgets greater than $1 million.

5. Find the employees who work in the Operations department and print the information (eid, ename, age, and salary) for each employee. The output should be ordered by ename.