groupingfunc48.ans

-- @author tungs1
-- @modified 2013-07-28 12:00:00
-- @created 2013-07-28 12:00:00
-- @description groupingfunction groupingfunc48.sql
-- @db_name groupingfunction
-- @executemode normal
-- @tags groupingfunction
SELECT SUM(sale.pn) as g1 FROM product, sale WHERE product.pn=sale.pn GROUP BY ROLLUP((sale.pn),(product.pname),(sale.pn)) ORDER BY sale.pn, product.pname;
  g1  
------
  200
  200
  200
  400
  400
  400
  300
  300
  300
  800
  800
  800
 1000
 1000
 1000
  600
  600
  600
  700
  700
  700
  800
  800
  800
 4800
(25 rows)