Question

用SQL语句求下列题？

求基本表S中男同学的每一年龄组（超过50人）有多少人？
要求查询结果按人数升序排列，人数相同按年龄降序排列。

Answer 1

select age, count(*) as [人数] from S
where sex='男'
group by age
having count(*)>50
order by [人数]asc ,age desc