sql数据库查询语句

表结构如何？

1.select sum(score) as totalscore
from 学生表连接课程表(或者在WHERE加连接的条件)
ORDER BY SUM(SCORE) DESC

2.SELCET avg(score) as avescore,MIN(score) as minscore max(score) as maxscore
from 课程表 自己对具体表改改

select count(Score)
from student
order by Score desc

select avg(Score),max(Score),min(Score)
from course

表结构如何？以access为例
例：table_students
学生姓名，语文，数学，英语
name lang maths english
zhangsan 80 80 90
lisi 90 100 80
wangwu 100 70 80

统计总分
SELECT name,lang+maths+english
FROM Table_Students order by lang+maths+english asc
统计最高分
SELECT max(lang),max(maths),max(english)
FROM Table_Students ;
统计最低分
SELECT min(lang),min(maths),min(english)
FROM Table_Students ;
统计平均分
SELECT sum(lang)/(select count(*) from Table_Students),
sum(maths)/(select count(*) from Table_Students),
sum(english)/(select count(*