Country count

[Radeom]

I have database names and there are column country, name, id
like this:

Sweden, John, 1
Sweden, Carl, 1
Sweden, Bart, 2
Sweden, Bart, 3
Sweden, Benny, 4

Denmark, Adam, 5
Denmark, Aden, 5
Denmark, Paula, 6
Denmark, Paula, 7

Germany, Rahel, 8
Germany, Rahel, 8

how get:

Sweden 3
Denmark 2
Germany 1

PHP Code:

SELECT country, count(*) AS theCount FROM names GROUP BY country ORDER BY theCount DESC 


[BubikolRamios]

select t.state,count(distinct t.name) from temp_table t
group by t.state

[Radeom]

PHP Code:

SELECT country, count(distinct name) AS theCount FROM names GROUP BY country ORDER BY theCount DESC 


result is:

Sweden 4
Denmark 3
Germany 1

because no id
it does not work:

PHP Code:

SELECT country, count(distinct name and id) AS theCount FROM names GROUP BY country ORDER BY theCount DESC 


[BubikolRamios]

I looked to quick.
Explain what 3, in expected result, for sweden means ?

[Old Pedant]

*MAYBE* you are after this?

SELECT S.country, COUNT(  DISTINCT S.minid ) AS theCount
FROM (
    SELECT country, name, MIN(id) AS minid
    FROM names
    GROUP BY country, name 
    ) AS S
GROUP BY S.country
ORDER BY S.country

???