Posted by Greg D. Moore \(Strider\) on 04/23/07 00:23

"Erik Lautier" <lautier@gmail.com> wrote in message
news:1177283677.045638.109480@o5g2000hsb.googlegroups.com...
> Hi, I have a table that I insert a member's country into every time
> someone signs up. What I'd like to do is pull information from the DB
> such that I can see each country and the number of users from each.
> For example:
>
> Argentina 10
> Brazil 5
> Canada 3

W/o schema it's impossible to say what you want for sure but something like


create table membership
(
country varchar(20),
signup varchar(20)
);

insert into membership values ('Argentina', 'member 1')
insert into membership values ('Argentina', 'member 2')
insert into membership values ('Brazil', 'member 1')
insert into membership values ('Brazil', 'member 1')
insert into membership values ('Brazil', 'member 2')
insert into membership values ('Brazil', 'member 3')
insert into membership values ('Canada', 'member 1')

select country, count(signup) from membership group by country


SELECT COUNTRY, COUNT(signup) from membership group by country


>
> I'm having trouble writing the SQL for this...any suggestions?
>
> Thanks,
>
> Erik
>

--
Greg Moore
SQL Server DBA Consulting Remote and Onsite available!
Email: sql (at) greenms.com http://www.greenms.com/sqlserver.html

• Next in forum: Re: COUNT many but display just once?
• Prev in forum: COUNT many but display just once?
• Thread view: Re: COUNT many but display just once?

[Reply to this message]