MySQL数据库子查询练习——DDL与DML语句

数据

select createDaet from student where userName='赵六';
select *from student
where createDate>
(
select createDate from student where userName='赵六'
);
select courseid from score GROUP BY courseid ORDER BY avg(result) desc limit 1;
select courseName '课程名称',department '院系',number '人数'from course where id=
(
select courseid from score GROUP BY courseid ORDER BY avg (result)desc limit 1
);