检索“01“课程分数小于60，按分数降序排列的学生信息

建表语句点击详见

– 检索"01"课程分数小于60，按分数降序排列的学生信息

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 ;