eBay Interview Question

How do you code grouping in SQL?