Posted by Erik Lautier on 04/23/07 03:03

That did the trick. Thanks!

On Apr 22, 8:23 pm, "Greg D. Moore \(Strider\)"
<mooregr_deletet...@greenms.com> wrote:
> "Erik Lautier" <laut...@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: Rants. Difficulty to learn ETL tools?
• Prev in forum: Re: COUNT many but display just once?
• Thread view: Re: COUNT many but display just once?

[Reply to this message]