select COUNT(country) group by country count

Question

I'm trying to get the count of country visit on my site. I have a SQL table with uid, country and date. I'm then trying to pull count from SQL where I need the count in ordered array like

US - 53
UK - 47
CA - 45
and so on

It's been far to long time since I've played with SQL queries and I believe its my GROUP BY that fails.

SELECT COUNT(cfCountry) AS count FROM countryTracking GROUP BY cfCountry

But this just returns:

8
4
47
2
4
2
and so on

How do I make it return the count of the country in ordered with, plus the country in front?

Is this for `mysql` or Microsoft `sql-server`? You have both engines tagged. — SqlZim, Dec 25 '16 at 14:08

score 0 · Answer 1 · edited Dec 25 '16 at 17:14

0

You can try to add a count find like this

SELECT 
    country,
    COUNT(country) as count
FROM countryTracking
GROUP BY country
ORDER BY COUNT(country)

edited Dec 25 '16 at 17:14

MZaragoza

10,108
9
71
116

answered Dec 25 '16 at 14:04

Rabid Penguin

1,084
9
22

score 0 · Answer 2 · edited Dec 25 '16 at 16:10

0

SELECT COUNT(cfCountry) AS COUNT,
       cfCountry
FROM countryTracking
GROUP BY cfCountry
ORDER BY COUNT DESC;

edited Dec 25 '16 at 16:10

Gurwinder Singh

38,557
6
51
76

answered Dec 25 '16 at 14:05

Calvin

605
10
26

score -1 · Accepted Answer · answered Dec 25 '16 at 14:04

-1

Simply adding the field you want to show alongside the count should show this in your resultset.

SELECT cfCountry, COUNT(cfCountry) AS count
FROM countryTracking c
GROUP BY cfCountry

answered Dec 25 '16 at 14:04

Xamthi

34
6

Thanks for this reply, I will mark this one as accepted as you wrote what the issue was, thank you and it worked nicely. – GeekCoder Dec 25 '16 at 14:08
Glad I could help – Xamthi Dec 25 '16 at 14:12

select COUNT(country) group by country count

3 Answers3