1.DDL
CREATE TABLE `course` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`courseName` varchar(20) NOT NULL COMMENT '课程名称',
`department` varchar(30) NOT NULL,
`lv` int(11) DEFAULT NULL COMMENT '年级',
`number` int(11) DEFAULT NULL COMMENT '课程人数',
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
2.DML
select createDate 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;
)
3.DQL
select createDate 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;
)