groupingfunc62.ans

-- @author tungs1
-- @modified 2013-07-28 12:00:00
-- @created 2013-07-28 12:00:00
-- @description groupingfunction groupingfunc62.sql
-- @db_name groupingfunction
-- @executemode normal
-- @tags groupingfunction
-- order 1
SELECT GROUPING(product.pname) as g1, SUM(sale.pn) as g2 FROM product, sale WHERE product.pn=sale.pn GROUP BY GROUPING SETS (sale.pn, product.pname, sale.pn) ORDER BY g1,g2;
 g1 |  g2  
----+------
  0 |  200
  0 |  300
  0 |  400
  0 |  700
  0 |  800
  0 |  800
  0 | 1600
  1 |  200
  1 |  200
  1 |  300
  1 |  300
  1 |  400
  1 |  400
  1 |  600
  1 |  600
  1 |  700
  1 |  700
  1 |  800
  1 |  800
  1 |  800
  1 |  800
  1 | 1000
  1 | 1000
(23 rows)