-- Ensure you've run Item30StructureAndData.sql in the Sample Databases folder
-- in order to create the Inventory table

SET search_path = Item30Example;

-- Listing 5.6 GROUPING SETS sample query
SELECT Color, Dimension, SUM(Quantity) AS TotalQuantity
FROM Inventory 
GROUP BY GROUPING SETS ((Color), (Dimension), ());

