问题1:写出计算所有学生的英语平均成绩的sql语句
SELECT
AVG(english)
FROM
mark;
问题2:现有五个学生,其学号假定为11,22,33,44,55;请用一条sql语句实现列出的五个学生的数学成绩及其姓名,学生地址,电话号码;
SELECT
cust. NAME,
cust.Address,
cust.Telno,
mark.math
FROM
cust
JOIN mark ON cust.Studentno = mark.studentno
WHERE
cust.Studentno IN (11, 22, 33, 44, 55);
问题3:查询所有学生的姓名,计算机成绩,按计算机成绩从高到低排序
SELECT
cust. NAME,
FROM
cust
JOIN mark ON cust.Studentno = mark.studentno
ORDER BY
问题4:查询所有总成绩大于240分的学号,姓名,总成绩,按照总成绩由高到低排序;
SELECT
cust.Studentno,
cust. NAME,
SUM(
mark.english + mark.math + mark.computer
) pjf
FROM
cust
JOIN mark ON cust.Studentno = mark.studentno
WHERE
pjf > 240
ORDER BY
pjf DESC;
A:查询姓“王”的学生的个数
SELECT
COUNT(*)
FROM
student
WHERE
NAME LIKE '王';
B:查询‘数学’比‘语文’成绩高的所有学生的学号;
SELECT
FROM
SC
JOIN student ON SC.sid = student.id
JOIN course ON SC.cid = course. NAME
WHERE
SC.'数学' > SC '语文'
GROUP BY
C:查询平均成绩大于90分的同学的学号和平均成绩
SELECT
AVG(score)
FROM
Student
JOIN SC ON Student.id = SC.sid
GROUP BY
HAVING
AVG(score) > 90;