Yurttas/PL/DBL/mssql/F/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
10SELECT companyname 
11FROM Works 
12GROUP BY companyname 
13HAVING AVG(salary) > (SELECT AVG(salary) 
14                      FROM Works 
15                      WHERE companyname='First Bank Corporation');