where group by having order by desc 的用法

where group by having order by desc

1、简单版本：
SELECT
*
FROM
student stu
WHERE
s_age > 22
GROUP BY
s_no
HAVING
AVG( s_age ) > 22
ORDER BY
s_age DESC
LIMIT 5;

2、复杂升级版本

select count(tabcc.sno) as ‘满足条件数量’ from
(SELECT
sta.s_no as sno
FROM
student sta
WHERE
s_age > 22
GROUP BY
s_no
HAVING
AVG( s_age ) > 22
ORDER BY
s_age DESC
LIMIT 5) as tabcc;