select city from t where sex = '男' GROUP BY city ORDER BY avg(age) desc limit 3 select avg(age) from t where city in (select city from t where sex = '男' GROUP BY city ORDER BY avg(age) desc limit 3 ) group by city 两个 SQL 语句,不知道对不对,请大家指正
1 2

相关推荐

牛客网
牛客企业服务