Merchant - Reporting customers by region

dimestore wants to launch a regional marketing campaign and management wants a report of the number of customers per region grouped by postal code

ScreenShot

    SELECT COUNT(customer) AS customerCount, state
    FROM customer 
    GROUP BY state
    ORDER BY customerCount DESC