select nom, count(a.horaire)
from pokemon p LEFT JOIN apparition a 
ON p.id = a.idPokemon
GROUP BY p.id,nom
ORDER BY COUNT(a.horaire) DESC;