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

    1. SELECT
    2. FROM
    3. Student a
    4. LEFT JOIN
    5. Score b
    6. ON
    7. a.s_id = b.s_id
    8. WHERE b.c_id='01'
    9. AND b.s_score < 60
    10. ORDER BY b.s_score DESC