数据库基础知识学习（一）

数据库中有如下两张表：

student   

score

-- 统计一年级每个班级每个学生的总分
select st.grade,st.class,st.name,st.number,sum(sc.语文+sc.数学+sc.英语+sc.体育) as total
from student as st,score as sc 
where st.grade='一年级'
group by st.grade,st.class,st.name,st.number,sc.number
having  st.number=sc.number;

结果如下：

-- 查找一年级语文成绩最高的学生
select st.grade,st.class,st.name,st.number,sc.语文
from student as st,score as sc 
where st.number=sc.number and st.grade='一年级' and 
sc.语文=(
select max(sc.语文)
from student as st,score as sc 
where st.number=sc.number)

结果如下：