This example uses the Orders table to estimate the variance of freight costs for orders shipped to the United Kingdom.
SELECT Var(Freight) AS [UK Freight Variance]
FROM Orders WHERE ShipCountry = 'UK';
SELECT VarP(Freight) AS [UK Freight VarianceP]
FROM Orders
WHERE ShipCountry = 'UK';