groupingfunc118.ans

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