Listing E

insert into

   emp_salary_summary

(

   sum_salaries

   max_salary,

   min_salary,

   avg_salary,

values

(

   (select sum(salary) from emp),

   (select max(salary) from emp),

   (select min(salary) from emp),

   (select avg(salary) from emp)

;