SELECT occupation_id, gender, COUNT(*) FROM ratings INNER JOIN users ON ratings.user_id = users.id GROUP BY 1, 2 ORDER BY 1, 2