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'