Two counts in one sql statement

From: <>
Date: Mon, 20 Jul 2009 08:39:02 -0700 (PDT)
Message-ID: <>

I have a table with 3 fields.

country state city

USA        CA     Los Angeles
USA        CA      Sacramento
USA        OR     Portland

Canada ONT Ottawa

Could I find total count for the US and counts for country-state combo with one sql statement. I doubt whether this is possible. The output should look like:
country state C/S combo Total C(ountry) count

USA        CA          2                  3   (2 in CA + 1 in OR)
USA        OR          1                  3

TIA. Received on Mon Jul 20 2009 - 10:39:02 CDT

Original text of this message