Untitled

Anonymous
plain_text
11/25/2021 4:31 PM
344 B
26
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...