Yurttas/PL/DBL/oracle/F/01/Company-B/q12.sql

 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');