I have CREATE TABLE t (country text, city text);
I want to get with 1 query,
select count(country),country GROUP BY country ORDER BY count(country) DESC
And for each country, to get the same for cities.
Is it possible ?
Thanks