Consider an employee database with two relations employee (employee-name, street, and city) works (employee-name, company-name, salary) where

Question:

Consider an employee database with two relations employee (employee-name, street, and city) works (employee-name, company-name, salary) where the primary keys are underlined. Write a query to find companies whose employees earn a higher salary, on average, than the average salary at First Bank Corporation.

a. Using SQL: 1999 functions as appropriate.

b. Without using SQL: 1999 functions.