请用一段mySQL查询出每个职业类型下用户年龄从高到低前5名的customer_id及该id对应的年龄、月收入

SELECT c.customer_id, c.age, c.monthly_income FROM customers c JOIN ( SELECT occupation, MAX(age) AS max_age FROM customers GROUP BY occupation ) m ON c.occupation = m.occupation AND c.age <= m.max_age ORDER BY c.occupation, c.age DESC LIMIT 5