How to select parent item and child with highest count using SQL

So this is my database and this is my code for now

select distinct continentname, countryname, max(numberoflanguages)
from continent
inner join country on continent.continent = country.continent
group by continentname, countryname
order by continentname


It still shows every single continent but I need the top 1 country in every single continent who have the most numberoflanguages.

Kind of like this as output



Please correct me.

Continue reading...