MySQL 查询每个职业类型下年龄最高前五用户

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