Code example $5-1$

SELECT VendorState, VendorCity, VendorName, COUNT$(*)$ AS InvoiceQty,

SUM$($InvoiceTotal$)$ AS InvoiceAvg

FROM Invoices i

JOIN Vendors v

ON i$.$VendorID $=$ v$.$VendorID

WHERE VendorState $<\text{'}$e$\text{'}$

GROUP BY VendorState, VendorCity, VendorName

HAVING SUM$($InvoiceTotal$)>500$

ORDER BY VendorState, VendorCity, VendorName;

The GROUPING SETS operator works like the ROLLUP and CUBE operators, but it$...$

a$.$ excludes summary rows

b$.$ doesn$$t add summary rows for specified groups

c$.$ allows you to use additional sets of parentheses to create composite groups

d$.$ only works with tables that have an even number of rows