How to display the maximum number of satellites for the planet?

Question

MySQL

select * from ( select NAME as `Название планет` , COUNT(Sputnik.Planet_idPlanet) as `Количество спутников` from Planet 
inner join Sputnik on Planet.idPlanet = Sputnik.Planet_idPlanet 
group by Sputnik.Planet_idPlanet ) as `results`
Where...;

I don't know how to write further to display the planet with the maximum number of satellites.
Subquery (displays the name and number of satellites of the planet), but I don’t know how to form the main query.
Please do not offer through limit 1. Through MAX please.

Answer 1

select `results`.`Название планет`, max(`results`.`Количество спутников`) from ...

Answer 2

I would denormalize the number of satellites into a planet property. The solution is trivial.

Answer 3

Something like this:

select max(moonCount) from (
    select 
        p.idPlanet, 
        count(m.idSputnik) moonCount
    from Planet p
    join Sputnik m on m.Planet_idPlanet = p.idPlanet
    group by p.idPlanet);