SELECT name, COUNT(*) AS pie FROM genres_movies INNER JOIN genres ON genres.id = genres_movies.genre_id GROUP BY name ORDER BY COUNT(*) DESC, name