数据库习题

数据库习题

1)

SELECT
	avg(english) 英语平均分
FROM
	mark;

SELECT
	a.Name 姓名,
	a.Telno 电话号码,
	a.Address 地址,
	b.math 数学成绩
FROM
	cust a
JOIN mark b ON a.Studentno = b.studentno
WHERE
	a.Studentno in (11,22,33,44,55);

SELECT
	a.Name 姓名,
	b.computer 计算机成绩
FROM
	cust a
JOIN mark b ON a.Studentno = b.studentno
ORDER BY
	c.math DESC;

SELECT
a.Studentno 学号,
a.Name 姓名,
b.math + b.computer + b.english 总成绩
FROM
cust a
JOIN mark b ON a.Studentno = b.studentno
WHERE
	b.math + b.computer + b.english > 240
ORDER BY
	b.math + b.computer + b.english DESC;

A.

SELECT
	COUNT(*)
FROM
	Student
WHERE
	name LIKE '王%';

C.

SELECT
	a.sid,
	AVG(a.score) 平均成绩
FROM
	sc a
JOIN course b ON a.cid = b.id
GROUP BY
	a.sid
HAVING
	AVG(score) > 90;