Chapter 4 Exercise 5

5. How many customers have an account balance of more than $400? (2)

SELECT Count(Customers.CustomerID) AS CountOfCustomerID
FROM Customers
WHERE (((Customers.AccountBalance)>400));