用SQL语句实现2张表的联立查询,要求包含Where,Order By 字句\(^o^)/~不要复制粘贴的哦

用SQL语句实现2张表的联立查询,要求包含Where,Order By 字句\(^o^)/~不要复制粘贴的哦
用SQL语句实现2张表的联立查询,要求包含Where,Order By 字句
\(^o^)/~不要复制粘贴的哦

用SQL语句实现2张表的联立查询,要求包含Where,Order By 字句\(^o^)/~不要复制粘贴的哦
student（sno,sname,dept）
SC(sno,cno,grade)
查询计算机系学生的姓名和C01课程的考试成绩,并按降序排序
select sname,grade
from student,SC
where student.sno=sc.sno and dept='CS' and cno='C01'
order by grade desc