Count Function Example
This example calculates the number of orders shipped to the United Kingdom.
SELECT Count([Ship Country]) FROM Orders WHERE [Ship Country] = 'UK'