src/test/regress/expected/qp_olap_group2_optimizer.out

--
-- One purpose of these tests is to make sure that ORCA can handle all these
-- queries, and not fall back to the Postgres planner. To detect that,
-- turn optimizer_trace_fallback on, and watch for "falling back to planner"
-- messages.
--
set optimizer_trace_fallback='on';
-- Query 1
SELECT GROUPING(product.pname) as g1 FROM product, sale WHERE product.pn=sale.pn GROUP BY GROUPING SETS (sale.pn, product.pname) ORDER BY g1;
 g1 
----
  0
  0
  0
  0
  0
  0
  0
  1
  1
  1
  1
  1
  1
  1
  1
(15 rows)

-- Query 2
SELECT GROUPING(product.pname) as g1 FROM product, sale WHERE product.pn=sale.pn GROUP BY GROUPING SETS (sale.pn, product.pname, sale.pn) ORDER BY g1;
 g1 
----
  0
  0
  0
  0
  0
  0
  0
  1
  1
  1
  1
  1
  1
  1
  1
  1
  1
  1
  1
  1
  1
  1
  1
(23 rows)

-- Query 3
SELECT GROUPING(product.pname) as g1 FROM product, sale WHERE product.pn=sale.pn GROUP BY GROUPING SETS ((sale.pn) ,(product.pname, sale.pn)) ORDER BY g1;
 g1 
----
  0
  0
  0
  0
  0
  0
  0
  0
  1
  1
  1
  1
  1
  1
  1
  1
(16 rows)

-- Query 4
SELECT GROUPING(product.pname) as g1 FROM product, sale WHERE product.pn=sale.pn GROUP BY ROLLUP((sale.pn,product.pname)) ORDER BY g1;
 g1 
----
  0
  0
  0
  0
  0
  0
  0
  0
  1
(9 rows)

-- Query 5
SELECT GROUPING(product.pname) as g1 FROM product, sale WHERE product.pn=sale.pn GROUP BY ROLLUP((sale.pn,product.pname,sale.pn)) ORDER BY g1;
 g1 
----
  0
  0
  0
  0
  0
  0
  0
  0
  1
(9 rows)

-- Query 6
SELECT GROUPING(product.pname) as g1 FROM product, sale WHERE product.pn=sale.pn GROUP BY ROLLUP((sale.pn),(product.pname),(sale.pn)) ORDER BY g1;
 g1 
----
  0
  0
  0
  0
  0
  0
  0
  0
  0
  0
  0
  0
  0
  0
  0
  0
  1
  1
  1
  1
  1
  1
  1
  1
  1
(25 rows)

-- Query 7
SELECT GROUPING(sale.pn) as g1 FROM product, sale WHERE product.pn=sale.pn GROUP BY GROUPING SETS (sale.pn, product.pname) ORDER BY g1;
 g1 
----
  0
  0
  0
  0
  0
  0
  0
  0
  1
  1
  1
  1
  1
  1
  1
(15 rows)

-- Query 8
SELECT GROUPING(sale.pn) as g1 FROM product, sale WHERE product.pn=sale.pn GROUP BY GROUPING SETS (sale.pn, product.pname, sale.pn) ORDER BY g1;
 g1 
----
  0
  0
  0
  0
  0
  0
  0
  0
  0
  0
  0
  0
  0
  0
  0
  0
  1
  1
  1
  1
  1
  1
  1
(23 rows)

-- Query 9
SELECT GROUPING(sale.pn) as g1 FROM product, sale WHERE product.pn=sale.pn GROUP BY GROUPING SETS ((sale.pn) ,(product.pname, sale.pn)) ORDER BY g1;
 g1 
----
  0
  0
  0
  0
  0
  0
  0
  0
  0
  0
  0
  0
  0
  0
  0
  0
(16 rows)

-- Query 10
SELECT GROUPING(sale.pn) as g1 FROM product, sale WHERE product.pn=sale.pn GROUP BY ROLLUP((sale.pn,product.pname)) ORDER BY g1;
 g1 
----
  0
  0
  0
  0
  0
  0
  0
  0
  1
(9 rows)

-- Query 11
SELECT GROUPING(sale.pn) as g1 FROM product, sale WHERE product.pn=sale.pn GROUP BY ROLLUP((sale.pn,product.pname,sale.pn)) ORDER BY g1;
 g1 
----
  0
  0
  0
  0
  0
  0
  0
  0
  1
(9 rows)

-- Query 12
SELECT GROUPING(sale.pn) as g1 FROM product, sale WHERE product.pn=sale.pn GROUP BY ROLLUP((sale.pn),(product.pname),(sale.pn)) ORDER BY g1;
 g1 
----
  0
  0
  0
  0
  0
  0
  0
  0
  0
  0
  0
  0
  0
  0
  0
  0
  0
  0
  0
  0
  0
  0
  0
  0
  1
(25 rows)

-- Query 13
SELECT GROUPING(sale.pn) + 1 as g1 FROM product, sale WHERE product.pn=sale.pn GROUP BY GROUPING SETS (sale.pn, product.pname) ORDER BY g1;
 g1 
----
  1
  1
  1
  1
  1
  1
  1
  1
  2
  2
  2
  2
  2
  2
  2
(15 rows)

-- Query 14
SELECT GROUPING(sale.pn) + 1 as g1 FROM product, sale WHERE product.pn=sale.pn GROUP BY GROUPING SETS (sale.pn, product.pname, sale.pn) ORDER BY g1;
 g1 
----
  1
  1
  1
  1
  1
  1
  1
  1
  1
  1
  1
  1
  1
  1
  1
  1
  2
  2
  2
  2
  2
  2
  2
(23 rows)

-- Query 15
SELECT GROUPING(sale.pn) + 1 as g1 FROM product, sale WHERE product.pn=sale.pn GROUP BY GROUPING SETS ((sale.pn) ,(product.pname, sale.pn)) ORDER BY g1;
 g1 
----
  1
  1
  1
  1
  1
  1
  1
  1
  1
  1
  1
  1
  1
  1
  1
  1
(16 rows)

-- Query 16
SELECT GROUPING(sale.pn) + 1 as g1 FROM product, sale WHERE product.pn=sale.pn GROUP BY ROLLUP((sale.pn,product.pname)) ORDER BY g1;
 g1 
----
  1
  1
  1
  1
  1
  1
  1
  1
  2
(9 rows)

-- Query 17
SELECT GROUPING(sale.pn) + 1 as g1 FROM product, sale WHERE product.pn=sale.pn GROUP BY ROLLUP((sale.pn,product.pname,sale.pn)) ORDER BY g1;
 g1 
----
  1
  1
  1
  1
  1
  1
  1
  1
  2
(9 rows)

-- Query 18
SELECT GROUPING(sale.pn) + 1 as g1 FROM product, sale WHERE product.pn=sale.pn GROUP BY ROLLUP((sale.pn),(product.pname),(sale.pn)) ORDER BY g1;
 g1 
----
  1
  1
  1
  1
  1
  1
  1
  1
  1
  1
  1
  1
  1
  1
  1
  1
  1
  1
  1
  1
  1
  1
  1
  1
  2
(25 rows)

-- Query 19
SELECT SUM(sale.pn) as g1 FROM product, sale WHERE product.pn=sale.pn GROUP BY GROUPING SETS (sale.pn, product.pname) ORDER BY g1;
  g1  
------
  200
  200
  300
  300
  400
  400
  600
  700
  700
  800
  800
  800
  800
 1000
 1600
(15 rows)

-- Query 20
SELECT SUM(sale.pn) as g1 FROM product, sale WHERE product.pn=sale.pn GROUP BY GROUPING SETS (sale.pn, product.pname, sale.pn) ORDER BY g1;
  g1  
------
  200
  200
  200
  300
  300
  300
  400
  400
  400
  600
  600
  700
  700
  700
  800
  800
  800
  800
  800
  800
 1000
 1000
 1600
(23 rows)

-- Query 21
SELECT SUM(sale.pn) as g1 FROM product, sale WHERE product.pn=sale.pn GROUP BY GROUPING SETS ((sale.pn) ,(product.pname, sale.pn)) ORDER BY g1;
  g1  
------
  200
  200
  300
  300
  400
  400
  600
  600
  700
  700
  800
  800
  800
  800
 1000
 1000
(16 rows)

-- Query 22
SELECT SUM(sale.pn) as g1 FROM product, sale WHERE product.pn=sale.pn GROUP BY ROLLUP((sale.pn,product.pname)) ORDER BY g1;
  g1  
------
  200
  300
  400
  600
  700
  800
  800
 1000
 4800
(9 rows)

-- Query 23
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 g1;
  g1  
------
  200
  300
  400
  600
  700
  800
  800
 1000
 4800
(9 rows)

-- Query 24
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 g1;
  g1  
------
  200
  200
  200
  300
  300
  300
  400
  400
  400
  600
  600
  600
  700
  700
  700
  800
  800
  800
  800
  800
  800
 1000
 1000
 1000
 4800
(25 rows)

-- Query 25
SELECT GROUPING(product.pname) as g1 FROM product, sale WHERE product.pn=sale.pn GROUP BY GROUPING SETS (sale.pn, product.pname) ORDER BY sale.pn, product.pname;
 g1 
----
  1
  1
  1
  1
  1
  1
  1
  1
  0
  0
  0
  0
  0
  0
  0
(15 rows)

-- Query 26
SELECT GROUPING(product.pname) as g1 FROM product, sale WHERE product.pn=sale.pn GROUP BY GROUPING SETS (sale.pn, product.pname, sale.pn) ORDER BY sale.pn, product.pname;
 g1 
----
  1
  1
  1
  1
  1
  1
  1
  1
  1
  1
  1
  1
  1
  1
  1
  1
  0
  0
  0
  0
  0
  0
  0
(23 rows)

-- Query 27
SELECT GROUPING(product.pname) as g1 FROM product, sale WHERE product.pn=sale.pn GROUP BY GROUPING SETS ((sale.pn) ,(product.pname, sale.pn)) ORDER BY sale.pn, product.pname;
 g1 
----
  0
  1
  0
  1
  0
  1
  0
  1
  0
  1
  0
  1
  0
  1
  0
  1
(16 rows)

-- Query 28
SELECT GROUPING(product.pname) as g1 FROM product, sale WHERE product.pn=sale.pn GROUP BY ROLLUP((sale.pn,product.pname)) ORDER BY sale.pn, product.pname;
 g1 
----
  0
  0
  0
  0
  0
  0
  0
  0
  1
(9 rows)

-- Query 29
SELECT GROUPING(product.pname) 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 
----
  0
  0
  0
  0
  0
  0
  0
  0
  1
(9 rows)

-- Query 30
SELECT GROUPING(product.pname) 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 
----
  0
  0
  1
  0
  0
  1
  0
  0
  1
  0
  0
  1
  0
  0
  1
  0
  0
  1
  0
  0
  1
  0
  0
  1
  1
(25 rows)

-- Query 31
SELECT GROUPING(sale.pn) as g1 FROM product, sale WHERE product.pn=sale.pn GROUP BY GROUPING SETS (sale.pn, product.pname) ORDER BY sale.pn, product.pname;
 g1 
----
  0
  0
  0
  0
  0
  0
  0
  0
  1
  1
  1
  1
  1
  1
  1
(15 rows)

-- Query 32
SELECT GROUPING(sale.pn) as g1 FROM product, sale WHERE product.pn=sale.pn GROUP BY GROUPING SETS (sale.pn, product.pname, sale.pn) ORDER BY sale.pn, product.pname;
 g1 
----
  0
  0
  0
  0
  0
  0
  0
  0
  0
  0
  0
  0
  0
  0
  0
  0
  1
  1
  1
  1
  1
  1
  1
(23 rows)

-- Query 33
SELECT GROUPING(sale.pn) as g1 FROM product, sale WHERE product.pn=sale.pn GROUP BY GROUPING SETS ((sale.pn) ,(product.pname, sale.pn)) ORDER BY sale.pn, product.pname;
 g1 
----
  0
  0
  0
  0
  0
  0
  0
  0
  0
  0
  0
  0
  0
  0
  0
  0
(16 rows)

-- Query 34
SELECT GROUPING(sale.pn) as g1 FROM product, sale WHERE product.pn=sale.pn GROUP BY ROLLUP((sale.pn,product.pname)) ORDER BY sale.pn, product.pname;
 g1 
----
  0
  0
  0
  0
  0
  0
  0
  0
  1
(9 rows)

-- Query 35
SELECT GROUPING(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 
----
  0
  0
  0
  0
  0
  0
  0
  0
  1
(9 rows)

-- Query 36
SELECT GROUPING(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 
----
  0
  0
  0
  0
  0
  0
  0
  0
  0
  0
  0
  0
  0
  0
  0
  0
  0
  0
  0
  0
  0
  0
  0
  0
  1
(25 rows)

-- Query 37
SELECT GROUPING(sale.pn) + 1 as g1 FROM product, sale WHERE product.pn=sale.pn GROUP BY GROUPING SETS (sale.pn, product.pname) ORDER BY sale.pn, product.pname;
 g1 
----
  1
  1
  1
  1
  1
  1
  1
  1
  2
  2
  2
  2
  2
  2
  2
(15 rows)

-- Query 38
SELECT GROUPING(sale.pn) + 1 as g1 FROM product, sale WHERE product.pn=sale.pn GROUP BY GROUPING SETS (sale.pn, product.pname, sale.pn) ORDER BY sale.pn, product.pname;
 g1 
----
  1
  1
  1
  1
  1
  1
  1
  1
  1
  1
  1
  1
  1
  1
  1
  1
  2
  2
  2
  2
  2
  2
  2
(23 rows)

-- Query 39
SELECT GROUPING(sale.pn) + 1 as g1 FROM product, sale WHERE product.pn=sale.pn GROUP BY GROUPING SETS ((sale.pn) ,(product.pname, sale.pn)) ORDER BY sale.pn, product.pname;
 g1 
----
  1
  1
  1
  1
  1
  1
  1
  1
  1
  1
  1
  1
  1
  1
  1
  1
(16 rows)

-- Query 40
SELECT GROUPING(sale.pn) + 1 as g1 FROM product, sale WHERE product.pn=sale.pn GROUP BY ROLLUP((sale.pn,product.pname)) ORDER BY sale.pn, product.pname;
 g1 
----
  1
  1
  1
  1
  1
  1
  1
  1
  2
(9 rows)

-- Query 41
SELECT GROUPING(sale.pn) + 1 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 
----
  1
  1
  1
  1
  1
  1
  1
  1
  2
(9 rows)

-- Query 42
SELECT GROUPING(sale.pn) + 1 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 
----
  1
  1
  1
  1
  1
  1
  1
  1
  1
  1
  1
  1
  1
  1
  1
  1
  1
  1
  1
  1
  1
  1
  1
  1
  2
(25 rows)

-- Query 43
SELECT SUM(sale.pn) as g1 FROM product, sale WHERE product.pn=sale.pn GROUP BY GROUPING SETS (sale.pn, product.pname) ORDER BY sale.pn, product.pname;
  g1  
------
  200
  400
  300
  800
 1000
  600
  700
  800
  300
 1600
  400
  800
  700
  800
  200
(15 rows)

-- Query 44
SELECT SUM(sale.pn) as g1 FROM product, sale WHERE product.pn=sale.pn GROUP BY GROUPING SETS (sale.pn, product.pname, sale.pn) ORDER BY sale.pn, product.pname;
  g1  
------
  200
  200
  400
  400
  300
  300
  800
  800
 1000
 1000
  600
  600
  700
  700
  800
  800
  300
 1600
  400
  800
  700
  800
  200
(23 rows)

-- Query 45
SELECT SUM(sale.pn) as g1 FROM product, sale WHERE product.pn=sale.pn GROUP BY GROUPING SETS ((sale.pn) ,(product.pname, sale.pn)) ORDER BY sale.pn, product.pname;
  g1  
------
  200
  200
  400
  400
  300
  300
  800
  800
 1000
 1000
  600
  600
  700
  700
  800
  800
(16 rows)

-- Query 46
SELECT SUM(sale.pn) as g1 FROM product, sale WHERE product.pn=sale.pn GROUP BY ROLLUP((sale.pn,product.pname)) ORDER BY sale.pn, product.pname;
  g1  
------
  200
  400
  300
  800
 1000
  600
  700
  800
 4800
(9 rows)

-- Query 47
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
  400
  300
  800
 1000
  600
  700
  800
 4800
(9 rows)

-- Query 48
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)

-- Query 49
SELECT GROUPING(product.pname) as g1, GROUPING(sale.pn) as g2 FROM product, sale WHERE product.pn=sale.pn GROUP BY GROUPING SETS (sale.pn, product.pname) ORDER BY g1,g2;
 g1 | g2 
----+----
  0 |  1
  0 |  1
  0 |  1
  0 |  1
  0 |  1
  0 |  1
  0 |  1
  1 |  0
  1 |  0
  1 |  0
  1 |  0
  1 |  0
  1 |  0
  1 |  0
  1 |  0
(15 rows)

-- Query 50
SELECT GROUPING(product.pname) as g1, GROUPING(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 |  1
  0 |  1
  0 |  1
  0 |  1
  0 |  1
  0 |  1
  0 |  1
  1 |  0
  1 |  0
  1 |  0
  1 |  0
  1 |  0
  1 |  0
  1 |  0
  1 |  0
  1 |  0
  1 |  0
  1 |  0
  1 |  0
  1 |  0
  1 |  0
  1 |  0
  1 |  0
(23 rows)

-- Query 51
SELECT GROUPING(product.pname) as g1, GROUPING(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 |  0
  0 |  0
  0 |  0
  0 |  0
  0 |  0
  0 |  0
  0 |  0
  0 |  0
  1 |  0
  1 |  0
  1 |  0
  1 |  0
  1 |  0
  1 |  0
  1 |  0
  1 |  0
(16 rows)

-- Query 52
SELECT GROUPING(product.pname) as g1, GROUPING(sale.pn) as g2 FROM product, sale WHERE product.pn=sale.pn GROUP BY ROLLUP((sale.pn,product.pname)) ORDER BY g1,g2;
 g1 | g2 
----+----
  0 |  0
  0 |  0
  0 |  0
  0 |  0
  0 |  0
  0 |  0
  0 |  0
  0 |  0
  1 |  1
(9 rows)

-- Query 53
SELECT GROUPING(product.pname) as g1, GROUPING(sale.pn) as g2 FROM product, sale WHERE product.pn=sale.pn GROUP BY ROLLUP((sale.pn,product.pname,sale.pn)) ORDER BY g1,g2;
 g1 | g2 
----+----
  0 |  0
  0 |  0
  0 |  0
  0 |  0
  0 |  0
  0 |  0
  0 |  0
  0 |  0
  1 |  1
(9 rows)

-- Query 54
SELECT GROUPING(product.pname) as g1, GROUPING(sale.pn) as g2 FROM product, sale WHERE product.pn=sale.pn GROUP BY ROLLUP((sale.pn),(product.pname),(sale.pn)) ORDER BY g1,g2;
 g1 | g2 
----+----
  0 |  0
  0 |  0
  0 |  0
  0 |  0
  0 |  0
  0 |  0
  0 |  0
  0 |  0
  0 |  0
  0 |  0
  0 |  0
  0 |  0
  0 |  0
  0 |  0
  0 |  0
  0 |  0
  1 |  0
  1 |  0
  1 |  0
  1 |  0
  1 |  0
  1 |  0
  1 |  0
  1 |  0
  1 |  1
(25 rows)

-- Query 55
SELECT GROUPING(product.pname) as g1, GROUPING(sale.pn) + 1 as g2 FROM product, sale WHERE product.pn=sale.pn GROUP BY GROUPING SETS (sale.pn, product.pname) ORDER BY g1,g2;
 g1 | g2 
----+----
  0 |  2
  0 |  2
  0 |  2
  0 |  2
  0 |  2
  0 |  2
  0 |  2
  1 |  1
  1 |  1
  1 |  1
  1 |  1
  1 |  1
  1 |  1
  1 |  1
  1 |  1
(15 rows)

-- Query 56
SELECT GROUPING(product.pname) as g1, GROUPING(sale.pn) + 1 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 |  2
  0 |  2
  0 |  2
  0 |  2
  0 |  2
  0 |  2
  0 |  2
  1 |  1
  1 |  1
  1 |  1
  1 |  1
  1 |  1
  1 |  1
  1 |  1
  1 |  1
  1 |  1
  1 |  1
  1 |  1
  1 |  1
  1 |  1
  1 |  1
  1 |  1
  1 |  1
(23 rows)

-- Query 57
SELECT GROUPING(product.pname) as g1, GROUPING(sale.pn) + 1 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 |  1
  0 |  1
  0 |  1
  0 |  1
  0 |  1
  0 |  1
  0 |  1
  0 |  1
  1 |  1
  1 |  1
  1 |  1
  1 |  1
  1 |  1
  1 |  1
  1 |  1
  1 |  1
(16 rows)

-- Query 58
SELECT GROUPING(product.pname) as g1, GROUPING(sale.pn) + 1 as g2 FROM product, sale WHERE product.pn=sale.pn GROUP BY ROLLUP((sale.pn,product.pname)) ORDER BY g1,g2;
 g1 | g2 
----+----
  0 |  1
  0 |  1
  0 |  1
  0 |  1
  0 |  1
  0 |  1
  0 |  1
  0 |  1
  1 |  2
(9 rows)

-- Query 59
SELECT GROUPING(product.pname) as g1, GROUPING(sale.pn) + 1 as g2 FROM product, sale WHERE product.pn=sale.pn GROUP BY ROLLUP((sale.pn,product.pname,sale.pn)) ORDER BY g1,g2;
 g1 | g2 
----+----
  0 |  1
  0 |  1
  0 |  1
  0 |  1
  0 |  1
  0 |  1
  0 |  1
  0 |  1
  1 |  2
(9 rows)

-- Query 60
SELECT GROUPING(product.pname) as g1, GROUPING(sale.pn) + 1 as g2 FROM product, sale WHERE product.pn=sale.pn GROUP BY ROLLUP((sale.pn),(product.pname),(sale.pn)) ORDER BY g1,g2;
 g1 | g2 
----+----
  0 |  1
  0 |  1
  0 |  1
  0 |  1
  0 |  1
  0 |  1
  0 |  1
  0 |  1
  0 |  1
  0 |  1
  0 |  1
  0 |  1
  0 |  1
  0 |  1
  0 |  1
  0 |  1
  1 |  1
  1 |  1
  1 |  1
  1 |  1
  1 |  1
  1 |  1
  1 |  1
  1 |  1
  1 |  2
(25 rows)

-- Query 61
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) ORDER BY g1,g2;
 g1 |  g2  
----+------
  0 |  200
  0 |  300
  0 |  400
  0 |  700
  0 |  800
  0 |  800
  0 | 1600
  1 |  200
  1 |  300
  1 |  400
  1 |  600
  1 |  700
  1 |  800
  1 |  800
  1 | 1000
(15 rows)

-- Query 62
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)

-- Query 63
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 |  600
  0 |  700
  0 |  800
  0 |  800
  0 | 1000
  1 |  200
  1 |  300
  1 |  400
  1 |  600
  1 |  700
  1 |  800
  1 |  800
  1 | 1000
(16 rows)

-- Query 64
SELECT GROUPING(product.pname) as g1, SUM(sale.pn) as g2 FROM product, sale WHERE product.pn=sale.pn GROUP BY ROLLUP((sale.pn,product.pname)) ORDER BY g1,g2;
 g1 |  g2  
----+------
  0 |  200
  0 |  300
  0 |  400
  0 |  600
  0 |  700
  0 |  800
  0 |  800
  0 | 1000
  1 | 4800
(9 rows)

-- Query 65
SELECT GROUPING(product.pname) as g1, SUM(sale.pn) as g2 FROM product, sale WHERE product.pn=sale.pn GROUP BY ROLLUP((sale.pn,product.pname,sale.pn)) ORDER BY g1,g2;
 g1 |  g2  
----+------
  0 |  200
  0 |  300
  0 |  400
  0 |  600
  0 |  700
  0 |  800
  0 |  800
  0 | 1000
  1 | 4800
(9 rows)

-- Query 66
SELECT GROUPING(product.pname) as g1, SUM(sale.pn) as g2 FROM product, sale WHERE product.pn=sale.pn GROUP BY ROLLUP((sale.pn),(product.pname),(sale.pn)) ORDER BY g1,g2;
 g1 |  g2  
----+------
  0 |  200
  0 |  200
  0 |  300
  0 |  300
  0 |  400
  0 |  400
  0 |  600
  0 |  600
  0 |  700
  0 |  700
  0 |  800
  0 |  800
  0 |  800
  0 |  800
  0 | 1000
  0 | 1000
  1 |  200
  1 |  300
  1 |  400
  1 |  600
  1 |  700
  1 |  800
  1 |  800
  1 | 1000
  1 | 4800
(25 rows)

-- Query 67
SELECT GROUPING(sale.pn) as g1, GROUPING(product.pname) as g2 FROM product, sale WHERE product.pn=sale.pn GROUP BY GROUPING SETS (sale.pn, product.pname) ORDER BY g1,g2;
 g1 | g2 
----+----
  0 |  1
  0 |  1
  0 |  1
  0 |  1
  0 |  1
  0 |  1
  0 |  1
  0 |  1
  1 |  0
  1 |  0
  1 |  0
  1 |  0
  1 |  0
  1 |  0
  1 |  0
(15 rows)

-- Query 68
SELECT GROUPING(sale.pn) as g1, GROUPING(product.pname) 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 |  1
  0 |  1
  0 |  1
  0 |  1
  0 |  1
  0 |  1
  0 |  1
  0 |  1
  0 |  1
  0 |  1
  0 |  1
  0 |  1
  0 |  1
  0 |  1
  0 |  1
  0 |  1
  1 |  0
  1 |  0
  1 |  0
  1 |  0
  1 |  0
  1 |  0
  1 |  0
(23 rows)

-- Query 69
SELECT GROUPING(sale.pn) as g1, GROUPING(product.pname) 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 |  0
  0 |  0
  0 |  0
  0 |  0
  0 |  0
  0 |  0
  0 |  0
  0 |  0
  0 |  1
  0 |  1
  0 |  1
  0 |  1
  0 |  1
  0 |  1
  0 |  1
  0 |  1
(16 rows)

-- Query 70
SELECT GROUPING(sale.pn) as g1, GROUPING(product.pname) as g2 FROM product, sale WHERE product.pn=sale.pn GROUP BY ROLLUP((sale.pn,product.pname)) ORDER BY g1,g2;
 g1 | g2 
----+----
  0 |  0
  0 |  0
  0 |  0
  0 |  0
  0 |  0
  0 |  0
  0 |  0
  0 |  0
  1 |  1
(9 rows)

-- Query 71
SELECT GROUPING(sale.pn) as g1, GROUPING(product.pname) as g2 FROM product, sale WHERE product.pn=sale.pn GROUP BY ROLLUP((sale.pn,product.pname,sale.pn)) ORDER BY g1,g2;
 g1 | g2 
----+----
  0 |  0
  0 |  0
  0 |  0
  0 |  0
  0 |  0
  0 |  0
  0 |  0
  0 |  0
  1 |  1
(9 rows)

-- Query 72
SELECT GROUPING(sale.pn) as g1, GROUPING(product.pname) as g2 FROM product, sale WHERE product.pn=sale.pn GROUP BY ROLLUP((sale.pn),(product.pname),(sale.pn)) ORDER BY g1,g2;
 g1 | g2 
----+----
  0 |  0
  0 |  0
  0 |  0
  0 |  0
  0 |  0
  0 |  0
  0 |  0
  0 |  0
  0 |  0
  0 |  0
  0 |  0
  0 |  0
  0 |  0
  0 |  0
  0 |  0
  0 |  0
  0 |  1
  0 |  1
  0 |  1
  0 |  1
  0 |  1
  0 |  1
  0 |  1
  0 |  1
  1 |  1
(25 rows)

-- Query 73
SELECT GROUPING(sale.pn) as g1, GROUPING(sale.pn) + 1 as g2 FROM product, sale WHERE product.pn=sale.pn GROUP BY GROUPING SETS (sale.pn, product.pname) ORDER BY g1,g2;
 g1 | g2 
----+----
  0 |  1
  0 |  1
  0 |  1
  0 |  1
  0 |  1
  0 |  1
  0 |  1
  0 |  1
  1 |  2
  1 |  2
  1 |  2
  1 |  2
  1 |  2
  1 |  2
  1 |  2
(15 rows)

-- Query 74
SELECT GROUPING(sale.pn) as g1, GROUPING(sale.pn) + 1 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 |  1
  0 |  1
  0 |  1
  0 |  1
  0 |  1
  0 |  1
  0 |  1
  0 |  1
  0 |  1
  0 |  1
  0 |  1
  0 |  1
  0 |  1
  0 |  1
  0 |  1
  0 |  1
  1 |  2
  1 |  2
  1 |  2
  1 |  2
  1 |  2
  1 |  2
  1 |  2
(23 rows)

-- Query 75
SELECT GROUPING(sale.pn) as g1, GROUPING(sale.pn) + 1 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 |  1
  0 |  1
  0 |  1
  0 |  1
  0 |  1
  0 |  1
  0 |  1
  0 |  1
  0 |  1
  0 |  1
  0 |  1
  0 |  1
  0 |  1
  0 |  1
  0 |  1
  0 |  1
(16 rows)

-- Query 76
SELECT GROUPING(sale.pn) as g1, GROUPING(sale.pn) + 1 as g2 FROM product, sale WHERE product.pn=sale.pn GROUP BY ROLLUP((sale.pn,product.pname)) ORDER BY g1,g2;
 g1 | g2 
----+----
  0 |  1
  0 |  1
  0 |  1
  0 |  1
  0 |  1
  0 |  1
  0 |  1
  0 |  1
  1 |  2
(9 rows)

-- Query 77
SELECT GROUPING(sale.pn) as g1, GROUPING(sale.pn) + 1 as g2 FROM product, sale WHERE product.pn=sale.pn GROUP BY ROLLUP((sale.pn,product.pname,sale.pn)) ORDER BY g1,g2;
 g1 | g2 
----+----
  0 |  1
  0 |  1
  0 |  1
  0 |  1
  0 |  1
  0 |  1
  0 |  1
  0 |  1
  1 |  2
(9 rows)

-- Query 78
SELECT GROUPING(sale.pn) as g1, GROUPING(sale.pn) + 1 as g2 FROM product, sale WHERE product.pn=sale.pn GROUP BY ROLLUP((sale.pn),(product.pname),(sale.pn)) ORDER BY g1,g2;
 g1 | g2 
----+----
  0 |  1
  0 |  1
  0 |  1
  0 |  1
  0 |  1
  0 |  1
  0 |  1
  0 |  1
  0 |  1
  0 |  1
  0 |  1
  0 |  1
  0 |  1
  0 |  1
  0 |  1
  0 |  1
  0 |  1
  0 |  1
  0 |  1
  0 |  1
  0 |  1
  0 |  1
  0 |  1
  0 |  1
  1 |  2
(25 rows)

-- Query 79
SELECT GROUPING(sale.pn) as g1, SUM(sale.pn) as g2 FROM product, sale WHERE product.pn=sale.pn GROUP BY GROUPING SETS (sale.pn, product.pname) ORDER BY g1,g2;
 g1 |  g2  
----+------
  0 |  200
  0 |  300
  0 |  400
  0 |  600
  0 |  700
  0 |  800
  0 |  800
  0 | 1000
  1 |  200
  1 |  300
  1 |  400
  1 |  700
  1 |  800
  1 |  800
  1 | 1600
(15 rows)

-- Query 80
SELECT GROUPING(sale.pn) 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 |  200
  0 |  300
  0 |  300
  0 |  400
  0 |  400
  0 |  600
  0 |  600
  0 |  700
  0 |  700
  0 |  800
  0 |  800
  0 |  800
  0 |  800
  0 | 1000
  0 | 1000
  1 |  200
  1 |  300
  1 |  400
  1 |  700
  1 |  800
  1 |  800
  1 | 1600
(23 rows)

-- Query 81
SELECT GROUPING(sale.pn) 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 |  200
  0 |  300
  0 |  300
  0 |  400
  0 |  400
  0 |  600
  0 |  600
  0 |  700
  0 |  700
  0 |  800
  0 |  800
  0 |  800
  0 |  800
  0 | 1000
  0 | 1000
(16 rows)

-- Query 82
SELECT GROUPING(sale.pn) as g1, SUM(sale.pn) as g2 FROM product, sale WHERE product.pn=sale.pn GROUP BY ROLLUP((sale.pn,product.pname)) ORDER BY g1,g2;
 g1 |  g2  
----+------
  0 |  200
  0 |  300
  0 |  400
  0 |  600
  0 |  700
  0 |  800
  0 |  800
  0 | 1000
  1 | 4800
(9 rows)

-- Query 83
SELECT GROUPING(sale.pn) as g1, SUM(sale.pn) as g2 FROM product, sale WHERE product.pn=sale.pn GROUP BY ROLLUP((sale.pn,product.pname,sale.pn)) ORDER BY g1,g2;
 g1 |  g2  
----+------
  0 |  200
  0 |  300
  0 |  400
  0 |  600
  0 |  700
  0 |  800
  0 |  800
  0 | 1000
  1 | 4800
(9 rows)

-- Query 84
SELECT GROUPING(sale.pn) as g1, SUM(sale.pn) as g2 FROM product, sale WHERE product.pn=sale.pn GROUP BY ROLLUP((sale.pn),(product.pname),(sale.pn)) ORDER BY g1,g2;
 g1 |  g2  
----+------
  0 |  200
  0 |  200
  0 |  200
  0 |  300
  0 |  300
  0 |  300
  0 |  400
  0 |  400
  0 |  400
  0 |  600
  0 |  600
  0 |  600
  0 |  700
  0 |  700
  0 |  700
  0 |  800
  0 |  800
  0 |  800
  0 |  800
  0 |  800
  0 |  800
  0 | 1000
  0 | 1000
  0 | 1000
  1 | 4800
(25 rows)

-- Query 85
SELECT GROUPING(sale.pn) + 1 as g1, GROUPING(product.pname) as g2 FROM product, sale WHERE product.pn=sale.pn GROUP BY GROUPING SETS (sale.pn, product.pname) ORDER BY g1,g2;
 g1 | g2 
----+----
  1 |  1
  1 |  1
  1 |  1
  1 |  1
  1 |  1
  1 |  1
  1 |  1
  1 |  1
  2 |  0
  2 |  0
  2 |  0
  2 |  0
  2 |  0
  2 |  0
  2 |  0
(15 rows)

-- Query 86
SELECT GROUPING(sale.pn) + 1 as g1, GROUPING(product.pname) 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 
----+----
  1 |  1
  1 |  1
  1 |  1
  1 |  1
  1 |  1
  1 |  1
  1 |  1
  1 |  1
  1 |  1
  1 |  1
  1 |  1
  1 |  1
  1 |  1
  1 |  1
  1 |  1
  1 |  1
  2 |  0
  2 |  0
  2 |  0
  2 |  0
  2 |  0
  2 |  0
  2 |  0
(23 rows)

-- Query 87
SELECT GROUPING(sale.pn) + 1 as g1, GROUPING(product.pname) 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 
----+----
  1 |  0
  1 |  0
  1 |  0
  1 |  0
  1 |  0
  1 |  0
  1 |  0
  1 |  0
  1 |  1
  1 |  1
  1 |  1
  1 |  1
  1 |  1
  1 |  1
  1 |  1
  1 |  1
(16 rows)

-- Query 88
SELECT GROUPING(sale.pn) + 1 as g1, GROUPING(product.pname) as g2 FROM product, sale WHERE product.pn=sale.pn GROUP BY ROLLUP((sale.pn,product.pname)) ORDER BY g1,g2;
 g1 | g2 
----+----
  1 |  0
  1 |  0
  1 |  0
  1 |  0
  1 |  0
  1 |  0
  1 |  0
  1 |  0
  2 |  1
(9 rows)

-- Query 89
SELECT GROUPING(sale.pn) + 1 as g1, GROUPING(product.pname) as g2 FROM product, sale WHERE product.pn=sale.pn GROUP BY ROLLUP((sale.pn,product.pname,sale.pn)) ORDER BY g1,g2;
 g1 | g2 
----+----
  1 |  0
  1 |  0
  1 |  0
  1 |  0
  1 |  0
  1 |  0
  1 |  0
  1 |  0
  2 |  1
(9 rows)

-- Query 90
SELECT GROUPING(sale.pn) + 1 as g1, GROUPING(product.pname) as g2 FROM product, sale WHERE product.pn=sale.pn GROUP BY ROLLUP((sale.pn),(product.pname),(sale.pn)) ORDER BY g1,g2;
 g1 | g2 
----+----
  1 |  0
  1 |  0
  1 |  0
  1 |  0
  1 |  0
  1 |  0
  1 |  0
  1 |  0
  1 |  0
  1 |  0
  1 |  0
  1 |  0
  1 |  0
  1 |  0
  1 |  0
  1 |  0
  1 |  1
  1 |  1
  1 |  1
  1 |  1
  1 |  1
  1 |  1
  1 |  1
  1 |  1
  2 |  1
(25 rows)

-- Query 91
SELECT GROUPING(sale.pn) + 1 as g1, SUM(sale.pn) as g2 FROM product, sale WHERE product.pn=sale.pn GROUP BY GROUPING SETS (sale.pn, product.pname) ORDER BY g1,g2;
 g1 |  g2  
----+------
  1 |  200
  1 |  300
  1 |  400
  1 |  600
  1 |  700
  1 |  800
  1 |  800
  1 | 1000
  2 |  200
  2 |  300
  2 |  400
  2 |  700
  2 |  800
  2 |  800
  2 | 1600
(15 rows)

-- Query 92
SELECT GROUPING(sale.pn) + 1 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  
----+------
  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
  2 |  200
  2 |  300
  2 |  400
  2 |  700
  2 |  800
  2 |  800
  2 | 1600
(23 rows)

-- Query 93
SELECT GROUPING(sale.pn) + 1 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  
----+------
  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
(16 rows)

-- Query 94
SELECT GROUPING(sale.pn) + 1 as g1, SUM(sale.pn) as g2 FROM product, sale WHERE product.pn=sale.pn GROUP BY ROLLUP((sale.pn,product.pname)) ORDER BY g1,g2;
 g1 |  g2  
----+------
  1 |  200
  1 |  300
  1 |  400
  1 |  600
  1 |  700
  1 |  800
  1 |  800
  1 | 1000
  2 | 4800
(9 rows)

-- Query 95
SELECT GROUPING(sale.pn) + 1 as g1, SUM(sale.pn) as g2 FROM product, sale WHERE product.pn=sale.pn GROUP BY ROLLUP((sale.pn,product.pname,sale.pn)) ORDER BY g1,g2;
 g1 |  g2  
----+------
  1 |  200
  1 |  300
  1 |  400
  1 |  600
  1 |  700
  1 |  800
  1 |  800
  1 | 1000
  2 | 4800
(9 rows)

-- Query 96
SELECT GROUPING(sale.pn) + 1 as g1, SUM(sale.pn) as g2 FROM product, sale WHERE product.pn=sale.pn GROUP BY ROLLUP((sale.pn),(product.pname),(sale.pn)) ORDER BY g1,g2;
 g1 |  g2  
----+------
  1 |  200
  1 |  200
  1 |  200
  1 |  300
  1 |  300
  1 |  300
  1 |  400
  1 |  400
  1 |  400
  1 |  600
  1 |  600
  1 |  600
  1 |  700
  1 |  700
  1 |  700
  1 |  800
  1 |  800
  1 |  800
  1 |  800
  1 |  800
  1 |  800
  1 | 1000
  1 | 1000
  1 | 1000
  2 | 4800
(25 rows)

-- Query 97
SELECT SUM(sale.pn) as g1, GROUPING(product.pname) as g2 FROM product, sale WHERE product.pn=sale.pn GROUP BY GROUPING SETS (sale.pn, product.pname) ORDER BY g1,g2;
  g1  | g2 
------+----
  200 |  0
  200 |  1
  300 |  0
  300 |  1
  400 |  0
  400 |  1
  600 |  1
  700 |  0
  700 |  1
  800 |  0
  800 |  0
  800 |  1
  800 |  1
 1000 |  1
 1600 |  0
(15 rows)

-- Query 98
SELECT SUM(sale.pn) as g1, GROUPING(product.pname) 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 
------+----
  200 |  0
  200 |  1
  200 |  1
  300 |  0
  300 |  1
  300 |  1
  400 |  0
  400 |  1
  400 |  1
  600 |  1
  600 |  1
  700 |  0
  700 |  1
  700 |  1
  800 |  0
  800 |  0
  800 |  1
  800 |  1
  800 |  1
  800 |  1
 1000 |  1
 1000 |  1
 1600 |  0
(23 rows)

-- Query 99
SELECT SUM(sale.pn) as g1, GROUPING(product.pname) 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 
------+----
  200 |  0
  200 |  1
  300 |  0
  300 |  1
  400 |  0
  400 |  1
  600 |  0
  600 |  1
  700 |  0
  700 |  1
  800 |  0
  800 |  0
  800 |  1
  800 |  1
 1000 |  0
 1000 |  1
(16 rows)

-- Query 100
SELECT SUM(sale.pn) as g1, GROUPING(product.pname) as g2 FROM product, sale WHERE product.pn=sale.pn GROUP BY ROLLUP((sale.pn,product.pname)) ORDER BY g1,g2;
  g1  | g2 
------+----
  200 |  0
  300 |  0
  400 |  0
  600 |  0
  700 |  0
  800 |  0
  800 |  0
 1000 |  0
 4800 |  1
(9 rows)

-- Query 101
SELECT SUM(sale.pn) as g1, GROUPING(product.pname) as g2 FROM product, sale WHERE product.pn=sale.pn GROUP BY ROLLUP((sale.pn,product.pname,sale.pn)) ORDER BY g1,g2;
  g1  | g2 
------+----
  200 |  0
  300 |  0
  400 |  0
  600 |  0
  700 |  0
  800 |  0
  800 |  0
 1000 |  0
 4800 |  1
(9 rows)

-- Query 102
SELECT SUM(sale.pn) as g1, GROUPING(product.pname) as g2 FROM product, sale WHERE product.pn=sale.pn GROUP BY ROLLUP((sale.pn),(product.pname),(sale.pn)) ORDER BY g1,g2;
  g1  | g2 
------+----
  200 |  0
  200 |  0
  200 |  1
  300 |  0
  300 |  0
  300 |  1
  400 |  0
  400 |  0
  400 |  1
  600 |  0
  600 |  0
  600 |  1
  700 |  0
  700 |  0
  700 |  1
  800 |  0
  800 |  0
  800 |  0
  800 |  0
  800 |  1
  800 |  1
 1000 |  0
 1000 |  0
 1000 |  1
 4800 |  1
(25 rows)

-- Query 103
SELECT SUM(sale.pn) as g1, GROUPING(sale.pn) as g2 FROM product, sale WHERE product.pn=sale.pn GROUP BY GROUPING SETS (sale.pn, product.pname) ORDER BY g1,g2;
  g1  | g2 
------+----
  200 |  0
  200 |  1
  300 |  0
  300 |  1
  400 |  0
  400 |  1
  600 |  0
  700 |  0
  700 |  1
  800 |  0
  800 |  0
  800 |  1
  800 |  1
 1000 |  0
 1600 |  1
(15 rows)

-- Query 104
SELECT SUM(sale.pn) as g1, GROUPING(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 
------+----
  200 |  0
  200 |  0
  200 |  1
  300 |  0
  300 |  0
  300 |  1
  400 |  0
  400 |  0
  400 |  1
  600 |  0
  600 |  0
  700 |  0
  700 |  0
  700 |  1
  800 |  0
  800 |  0
  800 |  0
  800 |  0
  800 |  1
  800 |  1
 1000 |  0
 1000 |  0
 1600 |  1
(23 rows)

-- Query 105
SELECT SUM(sale.pn) as g1, GROUPING(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 
------+----
  200 |  0
  200 |  0
  300 |  0
  300 |  0
  400 |  0
  400 |  0
  600 |  0
  600 |  0
  700 |  0
  700 |  0
  800 |  0
  800 |  0
  800 |  0
  800 |  0
 1000 |  0
 1000 |  0
(16 rows)

-- Query 106
SELECT SUM(sale.pn) as g1, GROUPING(sale.pn) as g2 FROM product, sale WHERE product.pn=sale.pn GROUP BY ROLLUP((sale.pn,product.pname)) ORDER BY g1,g2;
  g1  | g2 
------+----
  200 |  0
  300 |  0
  400 |  0
  600 |  0
  700 |  0
  800 |  0
  800 |  0
 1000 |  0
 4800 |  1
(9 rows)

-- Query 107
SELECT SUM(sale.pn) as g1, GROUPING(sale.pn) as g2 FROM product, sale WHERE product.pn=sale.pn GROUP BY ROLLUP((sale.pn,product.pname,sale.pn)) ORDER BY g1,g2;
  g1  | g2 
------+----
  200 |  0
  300 |  0
  400 |  0
  600 |  0
  700 |  0
  800 |  0
  800 |  0
 1000 |  0
 4800 |  1
(9 rows)

-- Query 108
SELECT SUM(sale.pn) as g1, GROUPING(sale.pn) as g2 FROM product, sale WHERE product.pn=sale.pn GROUP BY ROLLUP((sale.pn),(product.pname),(sale.pn)) ORDER BY g1,g2;
  g1  | g2 
------+----
  200 |  0
  200 |  0
  200 |  0
  300 |  0
  300 |  0
  300 |  0
  400 |  0
  400 |  0
  400 |  0
  600 |  0
  600 |  0
  600 |  0
  700 |  0
  700 |  0
  700 |  0
  800 |  0
  800 |  0
  800 |  0
  800 |  0
  800 |  0
  800 |  0
 1000 |  0
 1000 |  0
 1000 |  0
 4800 |  1
(25 rows)

-- Query 109
SELECT SUM(sale.pn) as g1, GROUPING(sale.pn) + 1 as g2 FROM product, sale WHERE product.pn=sale.pn GROUP BY GROUPING SETS (sale.pn, product.pname) ORDER BY g1,g2;
  g1  | g2 
------+----
  200 |  1
  200 |  2
  300 |  1
  300 |  2
  400 |  1
  400 |  2
  600 |  1
  700 |  1
  700 |  2
  800 |  1
  800 |  1
  800 |  2
  800 |  2
 1000 |  1
 1600 |  2
(15 rows)

-- Query 110
SELECT SUM(sale.pn) as g1, GROUPING(sale.pn) + 1 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 
------+----
  200 |  1
  200 |  1
  200 |  2
  300 |  1
  300 |  1
  300 |  2
  400 |  1
  400 |  1
  400 |  2
  600 |  1
  600 |  1
  700 |  1
  700 |  1
  700 |  2
  800 |  1
  800 |  1
  800 |  1
  800 |  1
  800 |  2
  800 |  2
 1000 |  1
 1000 |  1
 1600 |  2
(23 rows)

-- Query 111
SELECT SUM(sale.pn) as g1, GROUPING(sale.pn) + 1 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 
------+----
  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 |  1
(16 rows)

-- Query 112
SELECT SUM(sale.pn) as g1, GROUPING(sale.pn) + 1 as g2 FROM product, sale WHERE product.pn=sale.pn GROUP BY ROLLUP((sale.pn,product.pname)) ORDER BY g1,g2;
  g1  | g2 
------+----
  200 |  1
  300 |  1
  400 |  1
  600 |  1
  700 |  1
  800 |  1
  800 |  1
 1000 |  1
 4800 |  2
(9 rows)

-- Query 113
SELECT SUM(sale.pn) as g1, GROUPING(sale.pn) + 1 as g2 FROM product, sale WHERE product.pn=sale.pn GROUP BY ROLLUP((sale.pn,product.pname,sale.pn)) ORDER BY g1,g2;
  g1  | g2 
------+----
  200 |  1
  300 |  1
  400 |  1
  600 |  1
  700 |  1
  800 |  1
  800 |  1
 1000 |  1
 4800 |  2
(9 rows)

-- Query 114
SELECT SUM(sale.pn) as g1, GROUPING(sale.pn) + 1 as g2 FROM product, sale WHERE product.pn=sale.pn GROUP BY ROLLUP((sale.pn),(product.pname),(sale.pn)) ORDER BY g1,g2;
  g1  | g2 
------+----
  200 |  1
  200 |  1
  200 |  1
  300 |  1
  300 |  1
  300 |  1
  400 |  1
  400 |  1
  400 |  1
  600 |  1
  600 |  1
  600 |  1
  700 |  1
  700 |  1
  700 |  1
  800 |  1
  800 |  1
  800 |  1
  800 |  1
  800 |  1
  800 |  1
 1000 |  1
 1000 |  1
 1000 |  1
 4800 |  2
(25 rows)

-- Query 115
SELECT GROUPING(product.pname) 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  
----+-----
  0 | 100
  0 | 200
  0 | 300
  0 | 400
  0 | 500
  0 | 600
  0 | 700
  0 | 800
(8 rows)

-- Query 116
SELECT GROUPING(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  
----+-----
  0 | 100
  0 | 200
  0 | 300
  0 | 400
  0 | 500
  0 | 600
  0 | 700
  0 | 800
(8 rows)

-- Query 117
SELECT GROUPING(sale.pn) + 1 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  
----+-----
  1 | 100
  1 | 200
  1 | 300
  1 | 400
  1 | 500
  1 | 600
  1 | 700
  1 | 800
(8 rows)

-- Query 118
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)

-- Query 119
SELECT GROUPING(product.pname) as g1, 'CONST' as g2 FROM product, sale WHERE product.pn=sale.pn GROUP BY product.pname,sale.pn ORDER BY g1,g2;
 g1 |  g2   
----+-------
  0 | CONST
  0 | CONST
  0 | CONST
  0 | CONST
  0 | CONST
  0 | CONST
  0 | CONST
  0 | CONST
(8 rows)

-- Query 120
SELECT GROUPING(sale.pn) as g1, 'CONST' as g2 FROM product, sale WHERE product.pn=sale.pn GROUP BY product.pname,sale.pn ORDER BY g1,g2;
 g1 |  g2   
----+-------
  0 | CONST
  0 | CONST
  0 | CONST
  0 | CONST
  0 | CONST
  0 | CONST
  0 | CONST
  0 | CONST
(8 rows)

-- Query 121
SELECT GROUPING(sale.pn) + 1 as g1, 'CONST' as g2 FROM product, sale WHERE product.pn=sale.pn GROUP BY product.pname,sale.pn ORDER BY g1,g2;
 g1 |  g2   
----+-------
  1 | CONST
  1 | CONST
  1 | CONST
  1 | CONST
  1 | CONST
  1 | CONST
  1 | CONST
  1 | CONST
(8 rows)

-- Query 122
SELECT SUM(sale.pn) as g1, 'CONST' as g2 FROM product, sale WHERE product.pn=sale.pn GROUP BY product.pname,sale.pn ORDER BY g1,g2;
  g1  |  g2   
------+-------
  200 | CONST
  300 | CONST
  400 | CONST
  600 | CONST
  700 | CONST
  800 | CONST
  800 | CONST
 1000 | CONST
(8 rows)

-- Query 123
SELECT GROUPING(product.pname) as g1 FROM product, sale WHERE product.pn=sale.pn GROUP BY sale.cn,product.pname,sale.pn ORDER BY sale.cn;
 g1 
----
  0
  0
  0
  0
  0
  0
  0
  0
  0
  0
  0
  0
(12 rows)

-- Query 124
SELECT GROUPING(sale.pn) as g1 FROM product, sale WHERE product.pn=sale.pn GROUP BY sale.cn,product.pname,sale.pn ORDER BY sale.cn;
 g1 
----
  0
  0
  0
  0
  0
  0
  0
  0
  0
  0
  0
  0
(12 rows)

-- Query 125
SELECT GROUPING(sale.pn) + 1 as g1 FROM product, sale WHERE product.pn=sale.pn GROUP BY sale.cn,product.pname,sale.pn ORDER BY sale.cn;
 g1 
----
  1
  1
  1
  1
  1
  1
  1
  1
  1
  1
  1
  1
(12 rows)

-- Query 126
-- order 1
select 'a',* from (SELECT SUM(sale.pn) as g1 FROM product, sale WHERE product.pn=sale.pn GROUP BY sale.cn,product.pname,sale.pn ORDER BY sale.cn) a;
 ?column? | g1  
----------+-----
 a        | 400
 a        | 100
 a        | 500
 a        | 200
 a        | 300
 a        | 100
 a        | 400
 a        | 600
 a        | 200
 a        | 500
 a        | 700
 a        | 800
(12 rows)

-- Query 127
SELECT GROUPING(product.pname) as g1, GROUPING(sale.pn) as g2 FROM product, sale WHERE product.pn=sale.pn GROUP BY product.pname, sale.pn ORDER BY g1,g2;
 g1 | g2 
----+----
  0 |  0
  0 |  0
  0 |  0
  0 |  0
  0 |  0
  0 |  0
  0 |  0
  0 |  0
(8 rows)

-- Query 128
SELECT GROUPING(product.pname) as g1, GROUPING(sale.pn) + 1 as g2 FROM product, sale WHERE product.pn=sale.pn GROUP BY product.pname, sale.pn ORDER BY g1,g2;
 g1 | g2 
----+----
  0 |  1
  0 |  1
  0 |  1
  0 |  1
  0 |  1
  0 |  1
  0 |  1
  0 |  1
(8 rows)

-- Query 129
SELECT GROUPING(product.pname) as g1, SUM(sale.pn) as g2 FROM product, sale WHERE product.pn=sale.pn GROUP BY product.pname, sale.pn ORDER BY g1,g2;
 g1 |  g2  
----+------
  0 |  200
  0 |  300
  0 |  400
  0 |  600
  0 |  700
  0 |  800
  0 |  800
  0 | 1000
(8 rows)

-- Query 130
SELECT GROUPING(sale.pn) as g1, GROUPING(product.pname) as g2 FROM product, sale WHERE product.pn=sale.pn GROUP BY product.pname, sale.pn ORDER BY g1,g2;
 g1 | g2 
----+----
  0 |  0
  0 |  0
  0 |  0
  0 |  0
  0 |  0
  0 |  0
  0 |  0
  0 |  0
(8 rows)

-- Query 131
SELECT GROUPING(sale.pn) as g1, GROUPING(sale.pn) + 1 as g2 FROM product, sale WHERE product.pn=sale.pn GROUP BY product.pname, sale.pn ORDER BY g1,g2;
 g1 | g2 
----+----
  0 |  1
  0 |  1
  0 |  1
  0 |  1
  0 |  1
  0 |  1
  0 |  1
  0 |  1
(8 rows)

-- Query 132
SELECT GROUPING(sale.pn) as g1, SUM(sale.pn) as g2 FROM product, sale WHERE product.pn=sale.pn GROUP BY product.pname, sale.pn ORDER BY g1,g2;
 g1 |  g2  
----+------
  0 |  200
  0 |  300
  0 |  400
  0 |  600
  0 |  700
  0 |  800
  0 |  800
  0 | 1000
(8 rows)

-- Query 133
SELECT GROUPING(sale.pn) + 1 as g1, GROUPING(product.pname) as g2 FROM product, sale WHERE product.pn=sale.pn GROUP BY product.pname, sale.pn ORDER BY g1,g2;
 g1 | g2 
----+----
  1 |  0
  1 |  0
  1 |  0
  1 |  0
  1 |  0
  1 |  0
  1 |  0
  1 |  0
(8 rows)

-- Query 134
SELECT GROUPING(sale.pn) + 1 as g1, SUM(sale.pn) as g2 FROM product, sale WHERE product.pn=sale.pn GROUP BY product.pname, sale.pn ORDER BY g1,g2;
 g1 |  g2  
----+------
  1 |  200
  1 |  300
  1 |  400
  1 |  600
  1 |  700
  1 |  800
  1 |  800
  1 | 1000
(8 rows)

-- Query 135
SELECT SUM(sale.pn) as g1, GROUPING(product.pname) as g2 FROM product, sale WHERE product.pn=sale.pn GROUP BY product.pname, sale.pn ORDER BY g1,g2;
  g1  | g2 
------+----
  200 |  0
  300 |  0
  400 |  0
  600 |  0
  700 |  0
  800 |  0
  800 |  0
 1000 |  0
(8 rows)

-- Query 136
SELECT SUM(sale.pn) as g1, GROUPING(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 |  0
  300 |  0
  400 |  0
  600 |  0
  700 |  0
  800 |  0
  800 |  0
 1000 |  0
(8 rows)

-- Query 137
SELECT SUM(sale.pn) as g1, GROUPING(sale.pn) + 1 as g2 FROM product, sale WHERE product.pn=sale.pn GROUP BY product.pname, sale.pn ORDER BY g1,g2;
  g1  | g2 
------+----
  200 |  1
  300 |  1
  400 |  1
  600 |  1
  700 |  1
  800 |  1
  800 |  1
 1000 |  1
(8 rows)

-- Query 138
SELECT GROUPING(product.pname) as g1, GROUPING(sale.pn) as g2 FROM product, sale WHERE product.pn=sale.pn GROUP BY sale.pn, product.pname ORDER BY g1,g2;
 g1 | g2 
----+----
  0 |  0
  0 |  0
  0 |  0
  0 |  0
  0 |  0
  0 |  0
  0 |  0
  0 |  0
(8 rows)

-- Query 139
SELECT GROUPING(product.pname) as g1, GROUPING(sale.pn) + 1 as g2 FROM product, sale WHERE product.pn=sale.pn GROUP BY sale.pn, product.pname ORDER BY g1,g2;
 g1 | g2 
----+----
  0 |  1
  0 |  1
  0 |  1
  0 |  1
  0 |  1
  0 |  1
  0 |  1
  0 |  1
(8 rows)

-- Query 140
SELECT GROUPING(product.pname) as g1, SUM(sale.pn) as g2 FROM product, sale WHERE product.pn=sale.pn GROUP BY sale.pn, product.pname ORDER BY g1,g2;
 g1 |  g2  
----+------
  0 |  200
  0 |  300
  0 |  400
  0 |  600
  0 |  700
  0 |  800
  0 |  800
  0 | 1000
(8 rows)

-- Query 141
SELECT GROUPING(sale.pn) as g1, GROUPING(product.pname) as g2 FROM product, sale WHERE product.pn=sale.pn GROUP BY sale.pn, product.pname ORDER BY g1,g2;
 g1 | g2 
----+----
  0 |  0
  0 |  0
  0 |  0
  0 |  0
  0 |  0
  0 |  0
  0 |  0
  0 |  0
(8 rows)

-- Query 142
SELECT GROUPING(sale.pn) as g1, GROUPING(sale.pn) + 1 as g2 FROM product, sale WHERE product.pn=sale.pn GROUP BY sale.pn, product.pname ORDER BY g1,g2;
 g1 | g2 
----+----
  0 |  1
  0 |  1
  0 |  1
  0 |  1
  0 |  1
  0 |  1
  0 |  1
  0 |  1
(8 rows)

-- Query 143
SELECT GROUPING(sale.pn) as g1, SUM(sale.pn) as g2 FROM product, sale WHERE product.pn=sale.pn GROUP BY sale.pn, product.pname ORDER BY g1,g2;
 g1 |  g2  
----+------
  0 |  200
  0 |  300
  0 |  400
  0 |  600
  0 |  700
  0 |  800
  0 |  800
  0 | 1000
(8 rows)

-- Query 144
SELECT GROUPING(sale.pn) + 1 as g1, GROUPING(product.pname) as g2 FROM product, sale WHERE product.pn=sale.pn GROUP BY sale.pn, product.pname ORDER BY g1,g2;
 g1 | g2 
----+----
  1 |  0
  1 |  0
  1 |  0
  1 |  0
  1 |  0
  1 |  0
  1 |  0
  1 |  0
(8 rows)

-- Query 145
SELECT GROUPING(sale.pn) + 1 as g1, SUM(sale.pn) as g2 FROM product, sale WHERE product.pn=sale.pn GROUP BY sale.pn, product.pname ORDER BY g1,g2;
 g1 |  g2  
----+------
  1 |  200
  1 |  300
  1 |  400
  1 |  600
  1 |  700
  1 |  800
  1 |  800
  1 | 1000
(8 rows)

-- Query 146
SELECT SUM(sale.pn) as g1, GROUPING(product.pname) as g2 FROM product, sale WHERE product.pn=sale.pn GROUP BY sale.pn, product.pname ORDER BY g1,g2;
  g1  | g2 
------+----
  200 |  0
  300 |  0
  400 |  0
  600 |  0
  700 |  0
  800 |  0
  800 |  0
 1000 |  0
(8 rows)

-- Query 147
SELECT SUM(sale.pn) as g1, GROUPING(sale.pn) as g2 FROM product, sale WHERE product.pn=sale.pn GROUP BY sale.pn, product.pname ORDER BY g1,g2;
  g1  | g2 
------+----
  200 |  0
  300 |  0
  400 |  0
  600 |  0
  700 |  0
  800 |  0
  800 |  0
 1000 |  0
(8 rows)

-- Query 148
SELECT SUM(sale.pn) as g1, GROUPING(sale.pn) + 1 as g2 FROM product, sale WHERE product.pn=sale.pn GROUP BY sale.pn, product.pname ORDER BY g1,g2;
  g1  | g2 
------+----
  200 |  1
  300 |  1
  400 |  1
  600 |  1
  700 |  1
  800 |  1
  800 |  1
 1000 |  1
(8 rows)

-- Query 149
SELECT sale.pn, GROUPING(product.pname) as g1 FROM product, sale WHERE product.pn=sale.pn GROUP BY GROUPING SETS (sale.pn, product.pname) ORDER BY 1,2;
 pn  | g1 
-----+----
 100 |  1
 200 |  1
 300 |  1
 400 |  1
 500 |  1
 600 |  1
 700 |  1
 800 |  1
     |  0
     |  0
     |  0
     |  0
     |  0
     |  0
     |  0
(15 rows)

-- Query 150
SELECT sale.pn, GROUPING(product.pname) as g1 FROM product, sale WHERE product.pn=sale.pn GROUP BY GROUPING SETS (sale.pn, product.pname, sale.pn) ORDER BY 1,2;
 pn  | g1 
-----+----
 100 |  1
 100 |  1
 200 |  1
 200 |  1
 300 |  1
 300 |  1
 400 |  1
 400 |  1
 500 |  1
 500 |  1
 600 |  1
 600 |  1
 700 |  1
 700 |  1
 800 |  1
 800 |  1
     |  0
     |  0
     |  0
     |  0
     |  0
     |  0
     |  0
(23 rows)

-- Query 151
SELECT sale.pn, GROUPING(product.pname) as g1 FROM product, sale WHERE product.pn=sale.pn GROUP BY GROUPING SETS ((sale.pn) ,(product.pname, sale.pn)) ORDER BY 1,2;
 pn  | g1 
-----+----
 100 |  0
 100 |  1
 200 |  0
 200 |  1
 300 |  0
 300 |  1
 400 |  0
 400 |  1
 500 |  0
 500 |  1
 600 |  0
 600 |  1
 700 |  0
 700 |  1
 800 |  0
 800 |  1
(16 rows)

-- Query 152
SELECT sale.pn, GROUPING(product.pname) as g1 FROM product, sale WHERE product.pn=sale.pn GROUP BY ROLLUP((sale.pn,product.pname)) ORDER BY 1,2;
 pn  | g1 
-----+----
 100 |  0
 200 |  0
 300 |  0
 400 |  0
 500 |  0
 600 |  0
 700 |  0
 800 |  0
     |  1
(9 rows)

-- Query 153
SELECT sale.pn, GROUPING(product.pname) as g1 FROM product, sale WHERE product.pn=sale.pn GROUP BY ROLLUP((sale.pn,product.pname,sale.pn)) ORDER BY 1,2;
 pn  | g1 
-----+----
 100 |  0
 200 |  0
 300 |  0
 400 |  0
 500 |  0
 600 |  0
 700 |  0
 800 |  0
     |  1
(9 rows)

-- Query 154
SELECT sale.pn, GROUPING(product.pname) as g1 FROM product, sale WHERE product.pn=sale.pn GROUP BY ROLLUP((sale.pn),(product.pname),(sale.pn)) ORDER BY 1,2;
 pn  | g1 
-----+----
 100 |  0
 100 |  0
 100 |  1
 200 |  0
 200 |  0
 200 |  1
 300 |  0
 300 |  0
 300 |  1
 400 |  0
 400 |  0
 400 |  1
 500 |  0
 500 |  0
 500 |  1
 600 |  0
 600 |  0
 600 |  1
 700 |  0
 700 |  0
 700 |  1
 800 |  0
 800 |  0
 800 |  1
     |  1
(25 rows)

-- Query 155
SELECT sale.pn, GROUPING(sale.pn) as g1 FROM product, sale WHERE product.pn=sale.pn GROUP BY GROUPING SETS (sale.pn, product.pname) ORDER BY 1,2;
 pn  | g1 
-----+----
 100 |  0
 200 |  0
 300 |  0
 400 |  0
 500 |  0
 600 |  0
 700 |  0
 800 |  0
     |  1
     |  1
     |  1
     |  1
     |  1
     |  1
     |  1
(15 rows)

-- Query 156
SELECT sale.pn, GROUPING(sale.pn) as g1 FROM product, sale WHERE product.pn=sale.pn GROUP BY GROUPING SETS (sale.pn, product.pname, sale.pn) ORDER BY 1,2;
 pn  | g1 
-----+----
 100 |  0
 100 |  0
 200 |  0
 200 |  0
 300 |  0
 300 |  0
 400 |  0
 400 |  0
 500 |  0
 500 |  0
 600 |  0
 600 |  0
 700 |  0
 700 |  0
 800 |  0
 800 |  0
     |  1
     |  1
     |  1
     |  1
     |  1
     |  1
     |  1
(23 rows)

-- Query 157
SELECT sale.pn, GROUPING(sale.pn) as g1 FROM product, sale WHERE product.pn=sale.pn GROUP BY GROUPING SETS ((sale.pn) ,(product.pname, sale.pn)) ORDER BY 1,2;
 pn  | g1 
-----+----
 100 |  0
 100 |  0
 200 |  0
 200 |  0
 300 |  0
 300 |  0
 400 |  0
 400 |  0
 500 |  0
 500 |  0
 600 |  0
 600 |  0
 700 |  0
 700 |  0
 800 |  0
 800 |  0
(16 rows)

-- Query 158
SELECT sale.pn, GROUPING(sale.pn) as g1 FROM product, sale WHERE product.pn=sale.pn GROUP BY ROLLUP((sale.pn,product.pname)) ORDER BY 1,2;
 pn  | g1 
-----+----
 100 |  0
 200 |  0
 300 |  0
 400 |  0
 500 |  0
 600 |  0
 700 |  0
 800 |  0
     |  1
(9 rows)

-- Query 159
SELECT sale.pn, GROUPING(sale.pn) as g1 FROM product, sale WHERE product.pn=sale.pn GROUP BY ROLLUP((sale.pn,product.pname,sale.pn)) ORDER BY 1,2;
 pn  | g1 
-----+----
 100 |  0
 200 |  0
 300 |  0
 400 |  0
 500 |  0
 600 |  0
 700 |  0
 800 |  0
     |  1
(9 rows)

-- Query 160
SELECT sale.pn, GROUPING(sale.pn) as g1 FROM product, sale WHERE product.pn=sale.pn GROUP BY ROLLUP((sale.pn),(product.pname),(sale.pn)) ORDER BY 1,2;
 pn  | g1 
-----+----
 100 |  0
 100 |  0
 100 |  0
 200 |  0
 200 |  0
 200 |  0
 300 |  0
 300 |  0
 300 |  0
 400 |  0
 400 |  0
 400 |  0
 500 |  0
 500 |  0
 500 |  0
 600 |  0
 600 |  0
 600 |  0
 700 |  0
 700 |  0
 700 |  0
 800 |  0
 800 |  0
 800 |  0
     |  1
(25 rows)

-- Query 161
SELECT sale.pn, GROUPING(sale.pn) + 1 as g1 FROM product, sale WHERE product.pn=sale.pn GROUP BY GROUPING SETS (sale.pn, product.pname) ORDER BY 1,2;
 pn  | g1 
-----+----
 100 |  1
 200 |  1
 300 |  1
 400 |  1
 500 |  1
 600 |  1
 700 |  1
 800 |  1
     |  2
     |  2
     |  2
     |  2
     |  2
     |  2
     |  2
(15 rows)

-- Query 162
SELECT sale.pn, GROUPING(sale.pn) + 1 as g1 FROM product, sale WHERE product.pn=sale.pn GROUP BY GROUPING SETS (sale.pn, product.pname, sale.pn) ORDER BY 1,2;
 pn  | g1 
-----+----
 100 |  1
 100 |  1
 200 |  1
 200 |  1
 300 |  1
 300 |  1
 400 |  1
 400 |  1
 500 |  1
 500 |  1
 600 |  1
 600 |  1
 700 |  1
 700 |  1
 800 |  1
 800 |  1
     |  2
     |  2
     |  2
     |  2
     |  2
     |  2
     |  2
(23 rows)

-- Query 163
SELECT sale.pn, GROUPING(sale.pn) + 1 as g1 FROM product, sale WHERE product.pn=sale.pn GROUP BY GROUPING SETS ((sale.pn) ,(product.pname, sale.pn)) ORDER BY 1,2;
 pn  | g1 
-----+----
 100 |  1
 100 |  1
 200 |  1
 200 |  1
 300 |  1
 300 |  1
 400 |  1
 400 |  1
 500 |  1
 500 |  1
 600 |  1
 600 |  1
 700 |  1
 700 |  1
 800 |  1
 800 |  1
(16 rows)

-- Query 164
SELECT sale.pn, GROUPING(sale.pn) + 1 as g1 FROM product, sale WHERE product.pn=sale.pn GROUP BY ROLLUP((sale.pn,product.pname)) ORDER BY 1,2;
 pn  | g1 
-----+----
 100 |  1
 200 |  1
 300 |  1
 400 |  1
 500 |  1
 600 |  1
 700 |  1
 800 |  1
     |  2
(9 rows)

-- Query 165
SELECT sale.pn, GROUPING(sale.pn) + 1 as g1 FROM product, sale WHERE product.pn=sale.pn GROUP BY ROLLUP((sale.pn,product.pname,sale.pn)) ORDER BY 1,2;
 pn  | g1 
-----+----
 100 |  1
 200 |  1
 300 |  1
 400 |  1
 500 |  1
 600 |  1
 700 |  1
 800 |  1
     |  2
(9 rows)

-- Query 166
SELECT sale.pn, GROUPING(sale.pn) + 1 as g1 FROM product, sale WHERE product.pn=sale.pn GROUP BY ROLLUP((sale.pn),(product.pname),(sale.pn)) ORDER BY 1,2;
 pn  | g1 
-----+----
 100 |  1
 100 |  1
 100 |  1
 200 |  1
 200 |  1
 200 |  1
 300 |  1
 300 |  1
 300 |  1
 400 |  1
 400 |  1
 400 |  1
 500 |  1
 500 |  1
 500 |  1
 600 |  1
 600 |  1
 600 |  1
 700 |  1
 700 |  1
 700 |  1
 800 |  1
 800 |  1
 800 |  1
     |  2
(25 rows)

-- Query 167
SELECT sale.pn, SUM(sale.pn) as g1 FROM product, sale WHERE product.pn=sale.pn GROUP BY GROUPING SETS (sale.pn, product.pname) ORDER BY 1,2;
 pn  |  g1  
-----+------
 100 |  200
 200 |  400
 300 |  300
 400 |  800
 500 | 1000
 600 |  600
 700 |  700
 800 |  800
     |  200
     |  300
     |  400
     |  700
     |  800
     |  800
     | 1600
(15 rows)

-- Query 168
SELECT sale.pn, SUM(sale.pn) as g1 FROM product, sale WHERE product.pn=sale.pn GROUP BY GROUPING SETS (sale.pn, product.pname, sale.pn) ORDER BY 1,2;
 pn  |  g1  
-----+------
 100 |  200
 100 |  200
 200 |  400
 200 |  400
 300 |  300
 300 |  300
 400 |  800
 400 |  800
 500 | 1000
 500 | 1000
 600 |  600
 600 |  600
 700 |  700
 700 |  700
 800 |  800
 800 |  800
     |  200
     |  300
     |  400
     |  700
     |  800
     |  800
     | 1600
(23 rows)

-- Query 169
SELECT sale.pn, SUM(sale.pn) as g1 FROM product, sale WHERE product.pn=sale.pn GROUP BY GROUPING SETS ((sale.pn) ,(product.pname, sale.pn)) ORDER BY 1,2;
 pn  |  g1  
-----+------
 100 |  200
 100 |  200
 200 |  400
 200 |  400
 300 |  300
 300 |  300
 400 |  800
 400 |  800
 500 | 1000
 500 | 1000
 600 |  600
 600 |  600
 700 |  700
 700 |  700
 800 |  800
 800 |  800
(16 rows)

-- Query 170
SELECT sale.pn, SUM(sale.pn) as g1 FROM product, sale WHERE product.pn=sale.pn GROUP BY ROLLUP((sale.pn,product.pname)) ORDER BY 1,2;
 pn  |  g1  
-----+------
 100 |  200
 200 |  400
 300 |  300
 400 |  800
 500 | 1000
 600 |  600
 700 |  700
 800 |  800
     | 4800
(9 rows)

-- Query 171
SELECT sale.pn, SUM(sale.pn) as g1 FROM product, sale WHERE product.pn=sale.pn GROUP BY ROLLUP((sale.pn,product.pname,sale.pn)) ORDER BY 1,2;
 pn  |  g1  
-----+------
 100 |  200
 200 |  400
 300 |  300
 400 |  800
 500 | 1000
 600 |  600
 700 |  700
 800 |  800
     | 4800
(9 rows)

-- Query 172
SELECT sale.pn, SUM(sale.pn) as g1 FROM product, sale WHERE product.pn=sale.pn GROUP BY ROLLUP((sale.pn),(product.pname),(sale.pn)) ORDER BY 1,2;
 pn  |  g1  
-----+------
 100 |  200
 100 |  200
 100 |  200
 200 |  400
 200 |  400
 200 |  400
 300 |  300
 300 |  300
 300 |  300
 400 |  800
 400 |  800
 400 |  800
 500 | 1000
 500 | 1000
 500 | 1000
 600 |  600
 600 |  600
 600 |  600
 700 |  700
 700 |  700
 700 |  700
 800 |  800
 800 |  800
 800 |  800
     | 4800
(25 rows)

-- Query 173
-- order 1
select 'a', * from ((SELECT GROUPING(product.pname) as g1 FROM product, sale WHERE product.pn=sale.pn GROUP BY GROUPING SETS (sale.pn, product.pname) ORDER BY g1) UNION (SELECT sale.pn FROM sale)) as a;
 ?column? | g1  
----------+-----
 a        | 200
 a        | 300
 a        | 100
 a        | 500
 a        | 700
 a        |   0
 a        |   1
 a        | 400
 a        | 600
 a        | 800
(10 rows)

-- Query 174
-- order 1
select 'a', * from ((SELECT GROUPING(product.pname) as g1 FROM product, sale WHERE product.pn=sale.pn GROUP BY GROUPING SETS (sale.pn, product.pname, sale.pn) ORDER BY g1) UNION (SELECT sale.pn FROM sale) )a;
 ?column? | g1  
----------+-----
 a        | 200
 a        | 600
 a        | 700
 a        | 100
 a        |   0
 a        | 400
 a        | 800
 a        | 300
 a        | 500
 a        |   1
(10 rows)

-- Query 175
-- order 1
select 'a', * from ((SELECT GROUPING(product.pname) as g1 FROM product, sale WHERE product.pn=sale.pn GROUP BY GROUPING SETS ((sale.pn) ,(product.pname, sale.pn)) ORDER BY g1) UNION (SELECT sale.pn FROM sale) )a;
 ?column? | g1  
----------+-----
 a        | 200
 a        | 600
 a        | 700
 a        | 100
 a        |   0
 a        | 400
 a        | 800
 a        | 300
 a        | 500
 a        |   1
(10 rows)

-- Query 176
-- order 1
select 'a', * from ((SELECT GROUPING(product.pname) as g1 FROM product, sale WHERE product.pn=sale.pn GROUP BY ROLLUP((sale.pn,product.pname)) ORDER BY g1) UNION (SELECT sale.pn FROM sale) )a;
 ?column? | g1  
----------+-----
 a        | 200
 a        | 100
 a        | 600
 a        | 700
 a        |   0
 a        | 800
 a        | 500
 a        |   1
 a        | 400
 a        | 300
(10 rows)

-- Query 177
-- order 1
select 'a', * from ((SELECT GROUPING(product.pname) as g1 FROM product, sale WHERE product.pn=sale.pn GROUP BY ROLLUP((sale.pn,product.pname,sale.pn)) ORDER BY g1) UNION (SELECT sale.pn FROM sale))a;
 ?column? | g1  
----------+-----
 a        | 800
 a        | 500
 a        |   1
 a        | 400
 a        | 300
 a        | 200
 a        | 100
 a        | 600
 a        | 700
 a        |   0
(10 rows)

-- Query 178
-- order 1
select 'a', * from ((SELECT GROUPING(product.pname) as g1 FROM product, sale WHERE product.pn=sale.pn GROUP BY ROLLUP((sale.pn),(product.pname),(sale.pn)) ORDER BY g1) UNION (SELECT sale.pn FROM sale))a;
 ?column? | g1  
----------+-----
 a        | 200
 a        | 600
 a        | 700
 a        | 100
 a        |   0
 a        | 400
 a        | 800
 a        | 300
 a        | 500
 a        |   1
(10 rows)

-- Query 179
-- order 1
select 'a', * from ((SELECT GROUPING(sale.pn) as g1 FROM product, sale WHERE product.pn=sale.pn GROUP BY GROUPING SETS (sale.pn, product.pname) ORDER BY g1) UNION (SELECT sale.pn FROM sale))a;
 ?column? | g1  
----------+-----
 a        | 200
 a        | 600
 a        | 700
 a        | 100
 a        |   0
 a        | 400
 a        | 800
 a        | 300
 a        | 500
 a        |   1
(10 rows)

-- Query 180
-- order 1
select 'a', * from ((SELECT GROUPING(sale.pn) as g1 FROM product, sale WHERE product.pn=sale.pn GROUP BY GROUPING SETS (sale.pn, product.pname, sale.pn) ORDER BY g1) UNION (SELECT sale.pn FROM sale))a;
 ?column? | g1  
----------+-----
 a        | 200
 a        | 600
 a        | 700
 a        | 100
 a        |   0
 a        | 400
 a        | 800
 a        | 300
 a        | 500
 a        |   1
(10 rows)

-- Query 181
-- order 1
select 'a', * from ((SELECT GROUPING(sale.pn) as g1 FROM product, sale WHERE product.pn=sale.pn GROUP BY GROUPING SETS ((sale.pn) ,(product.pname, sale.pn)) ORDER BY g1) UNION (SELECT sale.pn FROM sale))a;
 ?column? | g1  
----------+-----
 a        | 200
 a        | 600
 a        | 700
 a        | 100
 a        |   0
 a        | 400
 a        | 800
 a        | 300
 a        | 500
(9 rows)

-- Query 182
-- order 1
select 'a', * from ((SELECT GROUPING(sale.pn) as g1 FROM product, sale WHERE product.pn=sale.pn GROUP BY ROLLUP((sale.pn,product.pname)) ORDER BY g1) UNION (SELECT sale.pn FROM sale))a;
 ?column? | g1  
----------+-----
 a        | 800
 a        | 500
 a        |   1
 a        | 400
 a        | 300
 a        | 200
 a        | 100
 a        | 600
 a        | 700
 a        |   0
(10 rows)

-- Query 183
-- order 1
select 'a', * from ((SELECT GROUPING(sale.pn) as g1 FROM product, sale WHERE product.pn=sale.pn GROUP BY ROLLUP((sale.pn,product.pname,sale.pn)) ORDER BY g1) UNION (SELECT sale.pn FROM sale))a;
 ?column? | g1  
----------+-----
 a        | 200
 a        | 100
 a        | 600
 a        | 700
 a        |   0
 a        | 800
 a        | 500
 a        |   1
 a        | 400
 a        | 300
(10 rows)

-- Query 184
-- order 1
select 'a', * from ((SELECT GROUPING(sale.pn) as g1 FROM product, sale WHERE product.pn=sale.pn GROUP BY ROLLUP((sale.pn),(product.pname),(sale.pn)) ORDER BY g1) UNION (SELECT sale.pn FROM sale))a;
 ?column? | g1  
----------+-----
 a        | 200
 a        | 600
 a        | 700
 a        | 100
 a        |   0
 a        | 400
 a        | 800
 a        | 300
 a        | 500
 a        |   1
(10 rows)

-- Query 185
-- order 1
select 'a', * from ((SELECT GROUPING(sale.pn) + 1 as g1 FROM product, sale WHERE product.pn=sale.pn GROUP BY GROUPING SETS (sale.pn, product.pname) ORDER BY g1) UNION (SELECT sale.pn FROM sale))a;
 ?column? | g1  
----------+-----
 a        | 400
 a        | 800
 a        | 300
 a        | 500
 a        |   1
 a        | 200
 a        | 600
 a        |   2
 a        | 700
 a        | 100
(10 rows)

-- Query 186
-- order 1
select 'a', * from ((SELECT GROUPING(sale.pn) + 1 as g1 FROM product, sale WHERE product.pn=sale.pn GROUP BY GROUPING SETS (sale.pn, product.pname, sale.pn) ORDER BY g1) UNION (SELECT sale.pn FROM sale))a;
 ?column? | g1  
----------+-----
 a        | 400
 a        | 800
 a        | 300
 a        | 500
 a        |   1
 a        | 200
 a        | 600
 a        |   2
 a        | 700
 a        | 100
(10 rows)

-- Query 187
-- order 1
select 'a', * from ((SELECT GROUPING(sale.pn) + 1 as g1 FROM product, sale WHERE product.pn=sale.pn GROUP BY GROUPING SETS ((sale.pn) ,(product.pname, sale.pn)) ORDER BY g1) UNION (SELECT sale.pn FROM sale))a;
 ?column? | g1  
----------+-----
 a        | 400
 a        | 800
 a        | 300
 a        | 500
 a        |   1
 a        | 200
 a        | 600
 a        | 700
 a        | 100
(9 rows)

-- Query 188
-- order 1
select 'a', * from ((SELECT GROUPING(sale.pn) + 1 as g1 FROM product, sale WHERE product.pn=sale.pn GROUP BY ROLLUP((sale.pn,product.pname)) ORDER BY g1) UNION (SELECT sale.pn FROM sale))a;
 ?column? | g1  
----------+-----
 a        | 200
 a        |   2
 a        | 100
 a        | 600
 a        | 700
 a        | 800
 a        | 500
 a        |   1
 a        | 400
 a        | 300
(10 rows)

-- Query 189
-- order 1
select 'a', * from ((SELECT GROUPING(sale.pn) + 1 as g1 FROM product, sale WHERE product.pn=sale.pn GROUP BY ROLLUP((sale.pn,product.pname,sale.pn)) ORDER BY g1) UNION (SELECT sale.pn FROM sale))a;
 ?column? | g1  
----------+-----
 a        | 200
 a        |   2
 a        | 100
 a        | 600
 a        | 700
 a        | 800
 a        | 500
 a        |   1
 a        | 400
 a        | 300
(10 rows)

-- Query 190
-- order 1
select 'a', * from ((SELECT GROUPING(sale.pn) + 1 as g1 FROM product, sale WHERE product.pn=sale.pn GROUP BY ROLLUP((sale.pn),(product.pname),(sale.pn)) ORDER BY g1) UNION (SELECT sale.pn FROM sale))a;
 ?column? | g1  
----------+-----
 a        | 200
 a        | 600
 a        |   2
 a        | 700
 a        | 100
 a        | 400
 a        | 800
 a        | 300
 a        | 500
 a        |   1
(10 rows)

-- Query 191
-- order 1
select 'a', * from ((SELECT SUM(sale.pn) as g1 FROM product, sale WHERE product.pn=sale.pn GROUP BY GROUPING SETS (sale.pn, product.pname) ORDER BY g1) UNION (SELECT sale.pn FROM sale))a;
 ?column? |  g1  
----------+------
 a        |  400
 a        |  800
 a        |  300
 a        | 1000
 a        |  500
 a        |  200
 a        |  600
 a        |  700
 a        |  100
 a        | 1600
(10 rows)

-- Query 192
-- order 1
select 'a', * from ((SELECT SUM(sale.pn) as g1 FROM product, sale WHERE product.pn=sale.pn GROUP BY GROUPING SETS (sale.pn, product.pname, sale.pn) ORDER BY g1) UNION (SELECT sale.pn FROM sale))a;
 ?column? |  g1  
----------+------
 a        |  400
 a        |  800
 a        |  300
 a        | 1000
 a        |  500
 a        |  200
 a        |  600
 a        |  700
 a        |  100
 a        | 1600
(10 rows)

-- Query 193
-- order 1
select 'a', * from ((SELECT SUM(sale.pn) as g1 FROM product, sale WHERE product.pn=sale.pn GROUP BY GROUPING SETS ((sale.pn) ,(product.pname, sale.pn)) ORDER BY g1) UNION (SELECT sale.pn FROM sale))a;
 ?column? |  g1  
----------+------
 a        |  400
 a        |  800
 a        |  300
 a        | 1000
 a        |  500
 a        |  200
 a        |  600
 a        |  700
 a        |  100
(9 rows)

-- Query 194
-- order 1
select 'a', * from ((SELECT SUM(sale.pn) as g1 FROM product, sale WHERE product.pn=sale.pn GROUP BY ROLLUP((sale.pn,product.pname)) ORDER BY g1) UNION (SELECT sale.pn FROM sale))a;
 ?column? |  g1  
----------+------
 a        |  800
 a        | 1000
 a        |  500
 a        |  400
 a        |  300
 a        |  200
 a        |  100
 a        |  600
 a        |  700
 a        | 4800
(10 rows)

-- Query 195
-- order 1
select 'a', * from ((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 g1) UNION (SELECT sale.pn FROM sale))a;
 ?column? |  g1  
----------+------
 a        |  200
 a        |  100
 a        |  600
 a        |  700
 a        | 4800
 a        |  800
 a        | 1000
 a        |  500
 a        |  400
 a        |  300
(10 rows)

-- Query 196
-- order 1
select 'a', * from ((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 g1) UNION (SELECT sale.pn FROM sale))a;
 ?column? |  g1  
----------+------
 a        |  200
 a        |  600
 a        |  700
 a        |  100
 a        | 4800
 a        |  400
 a        |  800
 a        |  300
 a        | 1000
 a        |  500
(10 rows)

-- Query 197
-- order 1
select 'a', * from ((SELECT GROUPING(product.pname) as g1 FROM product, sale WHERE product.pn=sale.pn GROUP BY GROUPING SETS (sale.pn, product.pname) ORDER BY g1) UNION (SELECT GROUPING(product.pname) as g1 FROM product, sale WHERE product.pn=sale.pn GROUP BY GROUPING SETS (sale.pn, product.pname) ORDER BY g1))a;
 ?column? | g1 
----------+----
 a        |  1
 a        |  0
(2 rows)

-- Query 198
-- order 1
select 'a', * from ((SELECT GROUPING(product.pname) as g1 FROM product, sale WHERE product.pn=sale.pn GROUP BY GROUPING SETS (sale.pn, product.pname, sale.pn) ORDER BY g1) UNION (SELECT GROUPING(product.pname) as g1 FROM product, sale WHERE product.pn=sale.pn GROUP BY GROUPING SETS (sale.pn, product.pname, sale.pn) ORDER BY g1))a;
 ?column? | g1 
----------+----
 a        |  1
 a        |  0
(2 rows)

-- Query 199
-- order 1
select 'a', * from ((SELECT GROUPING(product.pname) as g1 FROM product, sale WHERE product.pn=sale.pn GROUP BY GROUPING SETS ((sale.pn) ,(product.pname, sale.pn)) ORDER BY g1) UNION (SELECT GROUPING(product.pname) as g1 FROM product, sale WHERE product.pn=sale.pn GROUP BY GROUPING SETS ((sale.pn) ,(product.pname, sale.pn)) ORDER BY g1))a;
 ?column? | g1 
----------+----
 a        |  0
 a        |  1
(2 rows)

-- Query 200
-- order 1
select 'a', * from ((SELECT GROUPING(product.pname) as g1 FROM product, sale WHERE product.pn=sale.pn GROUP BY ROLLUP((sale.pn,product.pname)) ORDER BY g1) UNION (SELECT GROUPING(product.pname) as g1 FROM product, sale WHERE product.pn=sale.pn GROUP BY ROLLUP((sale.pn,product.pname)) ORDER BY g1))a;
 ?column? | g1 
----------+----
 a        |  0
 a        |  1
(2 rows)

-- Query 201
-- order 1
select 'a', * from ((SELECT GROUPING(product.pname) as g1 FROM product, sale WHERE product.pn=sale.pn GROUP BY ROLLUP((sale.pn,product.pname,sale.pn)) ORDER BY g1) UNION (SELECT GROUPING(product.pname) as g1 FROM product, sale WHERE product.pn=sale.pn GROUP BY ROLLUP((sale.pn,product.pname,sale.pn)) ORDER BY g1))a;
 ?column? | g1 
----------+----
 a        |  1
 a        |  0
(2 rows)

-- Query 202
-- order 1
select 'a', * from ((SELECT GROUPING(product.pname) as g1 FROM product, sale WHERE product.pn=sale.pn GROUP BY ROLLUP((sale.pn),(product.pname),(sale.pn)) ORDER BY g1) UNION (SELECT GROUPING(product.pname) as g1 FROM product, sale WHERE product.pn=sale.pn GROUP BY ROLLUP((sale.pn),(product.pname),(sale.pn)) ORDER BY g1))a;
 ?column? | g1 
----------+----
 a        |  1
 a        |  0
(2 rows)

-- Query 203
-- order 1
select 'a', * from ((SELECT GROUPING(sale.pn) as g1 FROM product, sale WHERE product.pn=sale.pn GROUP BY GROUPING SETS (sale.pn, product.pname) ORDER BY g1) UNION (SELECT GROUPING(sale.pn) as g1 FROM product, sale WHERE product.pn=sale.pn GROUP BY GROUPING SETS (sale.pn, product.pname) ORDER BY g1))a;
 ?column? | g1 
----------+----
 a        |  1
 a        |  0
(2 rows)

-- Query 204
-- order 1
select 'a', * from ((SELECT GROUPING(sale.pn) as g1 FROM product, sale WHERE product.pn=sale.pn GROUP BY GROUPING SETS (sale.pn, product.pname, sale.pn) ORDER BY g1) UNION (SELECT GROUPING(sale.pn) as g1 FROM product, sale WHERE product.pn=sale.pn GROUP BY GROUPING SETS (sale.pn, product.pname, sale.pn) ORDER BY g1))a;
 ?column? | g1 
----------+----
 a        |  1
 a        |  0
(2 rows)

-- Query 205
-- order 1
select 'a', * from ((SELECT GROUPING(sale.pn) as g1 FROM product, sale WHERE product.pn=sale.pn GROUP BY GROUPING SETS ((sale.pn) ,(product.pname, sale.pn)) ORDER BY g1) UNION (SELECT GROUPING(sale.pn) as g1 FROM product, sale WHERE product.pn=sale.pn GROUP BY GROUPING SETS ((sale.pn) ,(product.pname, sale.pn)) ORDER BY g1))a;
 ?column? | g1 
----------+----
 a        |  0
(1 row)

-- Query 206
-- order 1
select 'a', * from ((SELECT GROUPING(sale.pn) as g1 FROM product, sale WHERE product.pn=sale.pn GROUP BY ROLLUP((sale.pn,product.pname)) ORDER BY g1) UNION (SELECT GROUPING(sale.pn) as g1 FROM product, sale WHERE product.pn=sale.pn GROUP BY ROLLUP((sale.pn,product.pname)) ORDER BY g1))a;
 ?column? | g1 
----------+----
 a        |  0
 a        |  1
(2 rows)

-- Query 207
-- order 1
select 'a', * from ((SELECT GROUPING(sale.pn) as g1 FROM product, sale WHERE product.pn=sale.pn GROUP BY ROLLUP((sale.pn,product.pname,sale.pn)) ORDER BY g1) UNION (SELECT GROUPING(sale.pn) as g1 FROM product, sale WHERE product.pn=sale.pn GROUP BY ROLLUP((sale.pn,product.pname,sale.pn)) ORDER BY g1))a;
 ?column? | g1 
----------+----
 a        |  0
 a        |  1
(2 rows)

-- Query 208
-- order 1
select 'a', * from ((SELECT GROUPING(sale.pn) as g1 FROM product, sale WHERE product.pn=sale.pn GROUP BY ROLLUP((sale.pn),(product.pname),(sale.pn)) ORDER BY g1) UNION (SELECT GROUPING(sale.pn) as g1 FROM product, sale WHERE product.pn=sale.pn GROUP BY ROLLUP((sale.pn),(product.pname),(sale.pn)) ORDER BY g1))a;
 ?column? | g1 
----------+----
 a        |  1
 a        |  0
(2 rows)

-- Query 209
-- order 1
select 'a', * from ((SELECT GROUPING(sale.pn) + 1 as g1 FROM product, sale WHERE product.pn=sale.pn GROUP BY GROUPING SETS (sale.pn, product.pname) ORDER BY g1) UNION (SELECT GROUPING(sale.pn) + 1 as g1 FROM product, sale WHERE product.pn=sale.pn GROUP BY GROUPING SETS (sale.pn, product.pname) ORDER BY g1))a;
 ?column? | g1 
----------+----
 a        |  2
 a        |  1
(2 rows)

-- Query 210
-- order 1
select 'a', * from ((SELECT GROUPING(sale.pn) + 1 as g1 FROM product, sale WHERE product.pn=sale.pn GROUP BY GROUPING SETS (sale.pn, product.pname, sale.pn) ORDER BY g1) UNION (SELECT GROUPING(sale.pn) + 1 as g1 FROM product, sale WHERE product.pn=sale.pn GROUP BY GROUPING SETS (sale.pn, product.pname, sale.pn) ORDER BY g1))a;
 ?column? | g1 
----------+----
 a        |  2
 a        |  1
(2 rows)

-- Query 211
-- order 1
select 'a', * from ((SELECT GROUPING(sale.pn) + 1 as g1 FROM product, sale WHERE product.pn=sale.pn GROUP BY GROUPING SETS ((sale.pn) ,(product.pname, sale.pn)) ORDER BY g1) UNION (SELECT GROUPING(sale.pn) + 1 as g1 FROM product, sale WHERE product.pn=sale.pn GROUP BY GROUPING SETS ((sale.pn) ,(product.pname, sale.pn)) ORDER BY g1))a;
 ?column? | g1 
----------+----
 a        |  1
(1 row)

-- Query 212
-- order 1
select 'a', * from ((SELECT GROUPING(sale.pn) + 1 as g1 FROM product, sale WHERE product.pn=sale.pn GROUP BY ROLLUP((sale.pn,product.pname)) ORDER BY g1) UNION (SELECT GROUPING(sale.pn) + 1 as g1 FROM product, sale WHERE product.pn=sale.pn GROUP BY ROLLUP((sale.pn,product.pname)) ORDER BY g1))a;
 ?column? | g1 
----------+----
 a        |  1
 a        |  2
(2 rows)

-- Query 213
-- order 1
select 'a', * from ((SELECT GROUPING(sale.pn) + 1 as g1 FROM product, sale WHERE product.pn=sale.pn GROUP BY ROLLUP((sale.pn,product.pname,sale.pn)) ORDER BY g1) UNION (SELECT GROUPING(sale.pn) + 1 as g1 FROM product, sale WHERE product.pn=sale.pn GROUP BY ROLLUP((sale.pn,product.pname,sale.pn)) ORDER BY g1))a;
 ?column? | g1 
----------+----
 a        |  2
 a        |  1
(2 rows)

-- Query 214
-- order 1
select 'a', * from ((SELECT GROUPING(sale.pn) + 1 as g1 FROM product, sale WHERE product.pn=sale.pn GROUP BY ROLLUP((sale.pn),(product.pname),(sale.pn)) ORDER BY g1) UNION (SELECT GROUPING(sale.pn) + 1 as g1 FROM product, sale WHERE product.pn=sale.pn GROUP BY ROLLUP((sale.pn),(product.pname),(sale.pn)) ORDER BY g1))a;
 ?column? | g1 
----------+----
 a        |  1
 a        |  2
(2 rows)

-- Query 215
-- order 1
select 'a', * from ((SELECT SUM(sale.pn) as g1 FROM product, sale WHERE product.pn=sale.pn GROUP BY GROUPING SETS (sale.pn, product.pname) ORDER BY g1) UNION (SELECT SUM(sale.pn) as g1 FROM product, sale WHERE product.pn=sale.pn GROUP BY GROUPING SETS (sale.pn, product.pname) ORDER BY g1))a;
 ?column? |  g1  
----------+------
 a        |  200
 a        |  600
 a        |  700
 a        | 1600
 a        |  400
 a        |  800
 a        |  300
 a        | 1000
(8 rows)

-- Query 216
-- order 1
select 'a', * from ((SELECT SUM(sale.pn) as g1 FROM product, sale WHERE product.pn=sale.pn GROUP BY GROUPING SETS (sale.pn, product.pname, sale.pn) ORDER BY g1) UNION (SELECT SUM(sale.pn) as g1 FROM product, sale WHERE product.pn=sale.pn GROUP BY GROUPING SETS (sale.pn, product.pname, sale.pn) ORDER BY g1))a;
 ?column? |  g1  
----------+------
 a        |  200
 a        |  600
 a        |  700
 a        | 1600
 a        |  400
 a        | 1000
 a        |  800
 a        |  300
(8 rows)

-- Query 217
-- order 1
select 'a', * from ((SELECT SUM(sale.pn) as g1 FROM product, sale WHERE product.pn=sale.pn GROUP BY GROUPING SETS ((sale.pn) ,(product.pname, sale.pn)) ORDER BY g1) UNION (SELECT SUM(sale.pn) as g1 FROM product, sale WHERE product.pn=sale.pn GROUP BY GROUPING SETS ((sale.pn) ,(product.pname, sale.pn)) ORDER BY g1))a;
 ?column? |  g1  
----------+------
 a        |  400
 a        |  800
 a        |  300
 a        | 1000
 a        |  200
 a        |  600
 a        |  700
(7 rows)

-- Query 218
-- order 1
select 'a', * from ((SELECT SUM(sale.pn) as g1 FROM product, sale WHERE product.pn=sale.pn GROUP BY ROLLUP((sale.pn,product.pname)) ORDER BY g1) UNION (SELECT SUM(sale.pn) as g1 FROM product, sale WHERE product.pn=sale.pn GROUP BY ROLLUP((sale.pn,product.pname)) ORDER BY g1))a;
 ?column? |  g1  
----------+------
 a        |  200
 a        |  600
 a        |  700
 a        | 4800
 a        |  400
 a        |  800
 a        |  300
 a        | 1000
(8 rows)

-- Query 219
-- order 1
select 'a', * from ((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 g1) UNION (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 g1)) a;
 ?column? |  g1  
----------+------
 a        |  400
 a        |  800
 a        |  300
 a        | 1000
 a        |  200
 a        |  600
 a        |  700
 a        | 4800
(8 rows)

-- Query 220
-- order 1
select 'a', * from ((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 g1) UNION (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 g1))a;
 ?column? |  g1  
----------+------
 a        |  200
 a        |  600
 a        | 4800
 a        |  700
 a        |  400
 a        | 1000
 a        |  800
 a        |  300
(8 rows)