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