新建表
cust表
mark表
1.计算所有学生的英语平均成绩
SELECT
AVG(english)
FROM
mark;
运行结果:
2.查询五个学生的数学成绩、学生姓名、地址、电话
SELECT
mark.math,
cust. NAME,
cust.Address,
cust.Telno
FROM
cust
JOIN mark ON cust.Studentno = mark.studentno
WHERE cust.Studentno in (11,22,33,44,55);
运行结果:
3.查询所有学生的学生姓名、计算机成绩,按照计算机成绩由高到低排序
SELECT
cust.Name,
mark.computer
FROM
cust
JOIN mark ON cust.Studentno = mark.studentno
ORDER BY cust.Name,mark.computer
DESC;