Answer the following queries using the model languages given to the left.

(a) [TRC]- Find the last names and hiring dates of employees earning more than $100,000.

(b) [TRC]- For each project for which department E21 is responsible, find the name of the employee responsible for that project.

(c) List the last names of employees who earn more than [SQL] Managers.

(d) [SQL] Find the name(s) and number(s) of the highest paid employee(s). (e) [SQL] For each department, give the number of distinct projects.