1> select dnum,
          tot_salary = sum(salary) 
     from qq_emp2 
     group by dnum 
     
     

+------+--------------------+
|dnum  |tot_salary          |
+------+--------------------+
|3200  |           $24000.00|
|4200  |           $60640.50|
|4500  |            $3000.00|
|4900  |           $11803.50|
|5200  |            $7000.00|
+------+--------------------+
(5 rows)
  2> select dnum,
            avg_salary = avg(salary),
            tot_salary = sum(salary) 
     from qq_emp2 
     group by dnum 
     
     

+------+--------------------+--------------------+
|dnum  |avg_salary          |tot_salary          |
+------+--------------------+--------------------+
|3200  |            $8000.00|           $24000.00|
|4200  |            $7580.06|           $60640.50|
|4500  |            $3000.00|            $3000.00|
|4900  |            $3934.50|           $11803.50|
|5200  |            $7000.00|            $7000.00|
+------+--------------------+--------------------+
(5 rows)
  3> select dnum,
          tot_salary = sum(salary) 
     from qq_emp2 
     where sdate < '01-oct-1996' 
     group by dnum 
     
     

+------+--------------------+
|dnum  |tot_salary          |
+------+--------------------+
|3200  |           $19250.00|
|4200  |           $28750.00|
|5200  |            $7000.00|
+------+--------------------+
(3 rows)
  4> commit 
     
     

End of Request