热门

最新

红包

立Flag

投票

同城

发布
weixin_52238867
Coreleon
3 年前
trueweixin_52238867

INSERT
INTO Choose(SNO,CourseID,Score)
VALUES('S00002','C1 ','80');

INSERT
INTO Choose(SNO,CourseID,Score)
VALUES('S00002','C2 ','85');

INSERT
INTO Choose(SNO,CourseID,Score)
VALUES('S00003','C1 ','78');

INSERT
INTO Choose(SNO,CourseID,Score)
VALUES('S00003','C3 ','70');

SELECT SNO,NAME
FROM Student
WHERE College = '计算机学院';

SELECT DISTINCT *
FROM Student,course,choose
WHERE Age BETWEEN 20 AND 23;

SELECT COUNT(DISTINCT SNO)
FROM Student;

SELECT MAX(Score)
FROM Choose
WHERE CourseID = 'C1';

SELECT MIN(Score)
FROM Choose
WHERE CourseID = 'C1';

SELECT SUM(Score)
FROM Choose
WHERE CourseID = 'C1';

SELECT AVG(Score)
FROM Choose
WHERE CourseID = 'C1';

SELECT CourseID,CourseName
FROM Course
WHERE CourseBeforeID IS NULL;

SELECT Student.`SNO`,Student.`Name`,Course.`CourseName`,choose.`Score`
FROM student,choose,course
WHERE choose.`SNO` = student.`SNO` AND course.`CourseID` = choose.`CourseID`;

SELECT SNO,NAME,Age
FROM Student
WHERE College IN
(SELECT College
FROM Student
WHERE NAME = '张三'
);
评论
1
打赏
  • 复制链接
  • 举报
下一条：
CREATE TABLE student(SNO Varchar(20), Name Varchar(10), Age Integer, College Varchar(30));CREATE TABLE Course(CourseID Varchar(15), CourseNAME Varchar(30), CourseBeforeID Varchar(15));CREATE TABLE Choose(SNO Varchar(20), CourseID Varchar(30), Score DECIMAL(5,2));INSERTINTO student(SNO,Name,Age,College)VALUES('S00001','张三',20,'计算机学院');INSERTINTO student(SNO,Name,Age,College)VALUES('S00002','李四',19,'通信学院');INSERTINTO student(SNO,Name,Age,College)VALUES('S00003','张三',21 ,'计算机学院');INSERTINTO Course(CourseID,CourseName,CourseBeforeID)VALUES('C1','计算机引论',NULL);INSERTINTO Course(CourseID,CourseName,CourseBeforeID)VALUES('C2','C 语言 ','C1');INSERTINTO Course(CourseID,CourseName,CourseBeforeID)VALUES('C3','数据结构 ','C2');INSERTINTO Choose(SNO,CourseID,Score)VALUES('S00001','C1 ','95');INSERTINTO Choose(SNO,CourseID,Score)VALUES('S00001','C2 ','80');INSERTINTO Choose(SNO,CourseID,Score)VALUES('S00001','C3 ','84');