I found something really cool with SQL yesterday that I did not think it would do; give me the distinct count of a field.
For example, to calculate the number of payment terms being used for our customers in the UK I can use the following statement:
SELECT COUNT(DISTINCT [Payment Terms Code])
FROM [Customer]
WHERE [Country_Region Code]='GB'