Chapter 5, Problem 15E

Explanation of Solution

“avg_salary()” function:

A function that takes name of the company as an argument and finds the average salary of the employees is as follows,

create function avg_salary(cname varchar(15))

return integer

  declare result integer;

select avg(salary) into result

from works

where works.company...

Explanation of Solution

Structured Query Language (SQL) statement:

select company_name

from works

group by company_name

having avg(salary)>(select avg(salary)

  from works

  where company_name=’First Bank Corporation’)

Explanation:

• Gr...