Hello again! Now i stucked with another little problem.
I have a table:
Now i don't know how to get a city which has the most population in this table.
With my code:
SELECT City, COUNT(Name) AS Population_number FROM Person GROUP BY City;
I get this result:
But how to get this result:
To get a city which has the biggest population and output it.
How to filter it?
Thanks for any help in advance.