SELECT
st.*,
sc.s_score
FROM student st
LEFT JOIN score sc ON sc.s_id=st.s_id
WHERE sc.c_id='01' AND sc.s_score<60
ORDER BY sc.s_score DESC ;
-- 16、检索“01“课程分数小于60,按分数降序排列的学生信息
最新推荐文章于 2022-05-07 13:43:59 发布
SELECT
st.*,
sc.s_score
FROM student st
LEFT JOIN score sc ON sc.s_id=st.s_id
WHERE sc.c_id='01' AND sc.s_score<60
ORDER BY sc.s_score DESC ;