[GENERAL] select top_countries and for each country, select top_cities in that country, in 1 query

[Dorian Hoxha]

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