eBay interview question

How do you code grouping in SQL?