Need help creating a query..

From: <jkuteynospam_at_nycap.rr.com>
Date: Sun, 24 Feb 2002 00:10:57 GMT
Message-ID: <d3cg7u8u000k3aat1nqrnvdkt99blsnkpr_at_4ax.com>


How would I write the query from this statement...

How many people are in each unique state in the customers_table? Select the state and display the number of people in each.

Here is the customers_table and the fields in each...

customers_table

customerid
firstname
lastname
city
state
email

The states are listed here...
WA, AZ, WI, ID, HI, OR, SC, NC, CO

Thanks!

John Received on Sun Feb 24 2002 - 01:10:57 CET

Original text of this message