Untitled

 avatar
unknown
plain_text
4 years ago
257 B
6
Indexable
SELECT 
    CASE 
        WHEN grades.grade>7 THEN students.name 
        ELSE NULL
    END 
AS name, grades.grade, students.marks FROM students JOIN grades ON students.marks 
BETWEEN grades.min_mark AND grades.max_mark ORDER BY grades.grade DESC, name ASC;
Editor is loading...