Yurttas/PL/DBL/mysql-f-2010/01/Company-B/q12.sql

 1/*
 2REM
 3REM q12.sql
 4REM
 5REM Find those companies that pay more, on average,
 6REM than the average salary at 'First Bank Corporation'.
 7REM
 8*/
 9
10\. set-db.sql
11
12SELECT companyname
13FROM Works
14GROUP BY companyname
15HAVING AVG(salary) > (SELECT AVG(salary)
16                      FROM Works
17                      WHERE companyname='First Bank Corporation');