Yurttas/PL/DBL/oracle/F/01/Company-B/q12.sql
Jump to navigation
Jump to search
1REM
2REM q12.sql
3REM
4REM Find those companies that pay more, on average,
5REM than the average salary at 'First Bank Corporation'.
6REM
7
8
9SELECT companyname
10FROM Works
11GROUP BY companyname
12HAVING AVG(salary) > (SELECT AVG(salary)
13 FROM Works
14 WHERE companyname='First Bank Corporation');