SQL练习题50道

// 首先是数据库脚本

CREATE DATABASE babel;
USE `babel`;





CREATE TABLE `course` (
  `cid` int(20) unsigned NOT NULL AUTO_INCREMENT,
  `cname` varchar(10) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `tid` varchar(10) DEFAULT NULL,
  PRIMARY KEY (`cid`)
) ENGINE=InnoDB AUTO_INCREMENT=1000 DEFAULT CHARSET=utf8;



insert  into `course`(`cid`,`cname`,`tid`) values (1,'语文','02'),(2,'数学','01'),(3,'英语','03');

/*Table structure for table `sc` */

DROP TABLE IF EXISTS `sc`;

CREATE TABLE `sc` (
  `sid` int(20) unsigned NOT NULL AUTO_INCREMENT,
  `cid` varchar(10) NOT NULL DEFAULT '',
  `score` decimal(18,1) DEFAULT NULL,
  PRIMARY KEY (`sid`,`cid`)
) ENGINE=InnoDB AUTO_INCREMENT=1000 DEFAULT CHARSET=utf8;



insert  into `sc`(`sid`,`cid`,`score`) values (1,'01','80.0'),(1,'02','90.0'),(1,'03','99.0'),(2,'01','70.0'),(2,'02','60.0'),(2,'03','80.0'),(3,'01','80.0'),(3,'02','80.0'),(3,'03','80.0'),(4,'01','50.0'),(4,'02','30.0'),(4,'03','20.0'),(5,'01','76.0'),(5,'02','87.0'),(6,'01','31.0'),(6,'03','34.0'),(7,'01','98.0'),(7,'02','89.0'),(7,'03','98.0');


CREATE TABLE `student` (
  `SNO` varchar(10) DEFAULT NULL,
  `Sname` varchar(10) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `Sage` datetime DEFAULT NULL,
  `Ssex` varchar(10) CHA