Query SQL [PSQL]

Question

I need help with SQL ... I would like to know if it was possible to find the nation (s) that have the highest number of teams .... (a nation has a team if it has at least one driver of that nation in a team) ...

f1 driver ( id_driver , driver_name , team , country ) 

I managed to write the command that gives me the number of teams for each nation (I think that's right) ..... I can't understand how and where to use the 'max' command ... can you help me?

SELECT (country) ,count(team) 
FROM driver
GROUP BY country;

question from:https://stackoverflow.com/questions/65940733/query-sql-psql

Answer 1

in that solution you don't need max ,only you have to sort the result :

SELECT (country) ,count(distinct team) 
FROM driver
GROUP BY country
order by count(distinct team) DESC

and if you want the nation with the highest number of teams :

SELECT (country) ,count(distinct team) 
FROM driver
GROUP BY country
order by count(distinct team)  DESC
LIMIT 2