schooldb库——utf8字符集——utf8_general_ci排序规则
1.DDL
select courseId,avg(result)from score GROUP BY courseId HAVING avg(result)>71;
select *from course
where id in
select courseId from score GROUP BY courseId HAVING avg(result)>71
);
2.DML
select courseId,avg(result)from score GROUP BY courseId HAVING avg(result)>71;
select *from course
where id in
select courseId from score GROUP BY courseId HAVING avg(result)>71
);
3.DML
select courseId,avg(result)from score GROUP BY courseId HAVING avg(result)>71;
select *from course
where id in
select courseId from score GROUP BY courseId HAVING avg(result)>71
);