Count Function Example

This example uses the Orders table to calculate the number of orders shipped to the United Kingdom.

SELECT Count (ShipCountry) AS [UK Orders] 
FROM Orders
WHERE ShipCountry = 'UK';