Advanced Analytics—Technology and Tools: In-Database Analytics - Data Science and Big Data Analytics - page 471

SELECT r.product_id,
DATE_PART('year', r.order_datetime) AS year,
SUM(r.item_quantity) AS total,
GROUP_ID() AS group_id
FROM orders_recent r
WHERE r.product_id IN ( 15060 )
GROUP BY ROLLUP( r.product_id, DATE_PART('year',
r.order_datetime) ),
CUBE( r.product_id, DATE_PART('year', r.order_datetime) )
HAVING GROUP_ID() = 0
ORDER BY r.product_id,
DATE_PART('year', r.order_datetime),
GROUP_ID()
product_id year total group_id
15060 2013 5996 0
15060 2014 57 0
15060 6053 0
2013 5996 0
2014 57 0
6053 0