这是执行顺序的问题,
select sid avg(cmark) from mark where sid in (select sid from student where ssex='男') group by sid order by desc
where sid in (select sid from student where ssex='男')这是没有作用的
这是执行顺序的问题,
select sid avg(cmark) from mark where sid in (select sid from student where ssex='男') group by sid order by desc
where sid in (select sid from student where ssex='男')这是没有作用的