1> range of q is qq_emp2 
     

  2> retrieve (q.dnum,
               tot_salary = sum(q.salary by q.dnum) 
              ) 
     

+------+--------------------+
|dnum  |tot_salary          |
+------+--------------------+
|3200  |           $24000.00|
|4200  |           $60640.50|
|4500  |            $3000.00|
|4900  |           $11803.50|
|5200  |            $7000.00|
+------+--------------------+
(5 rows)
  3> retrieve (q.dnum,
               avg_salary = avg(q.salary by q.dnum),
               tot_salary = sum(q.salary by q.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)
  4> retrieve (q.dnum,
               avg_salary = avg(q.salary by q.dnum),
               tot_salary = sum(q.salary by q.dnum),
               bef_salary = sum(q.salary by q.dnum where q.sdate < 
     "01-oct-1996") 
              ) 
     

+------+--------------------+--------------------+--------------------+
|dnum  |avg_salary          |tot_salary          |bef_salary          |
+------+--------------------+--------------------+--------------------+
|3200  |            $8000.00|           $24000.00|           $19250.00|
|4200  |            $7580.06|           $60640.50|           $28750.00|
|4500  |            $3000.00|            $3000.00|               $0.00|
|4900  |            $3934.50|           $11803.50|               $0.00|
|5200  |            $7000.00|            $7000.00|            $7000.00|
+------+--------------------+--------------------+--------------------+
(5 rows)
End of Request