Re: Need help creating a query..
From: Patrick Morganti <patrickm_at_omniway.sm>
Date: 24 Feb 2002 03:54:26 -0800
Message-ID: <ce071c7.0202240354.6bf1e84d_at_posting.google.com>
Date: 24 Feb 2002 03:54:26 -0800
Message-ID: <ce071c7.0202240354.6bf1e84d_at_posting.google.com>
select state, count(*)
from customers_table
group by state
or, if you want to select only those specific states :
select state, count(*)
from customers_table
where state in ('WA','AZ','WI','ID','HI','OR','SC','NC','CO')
group by state
Regards
Patrick Morganti
Received on Sun Feb 24 2002 - 12:54:26 CET