select count(*) from users group by country
select name from users where country = 'xx'
select count(country) from users
select country from users