The Report

  • + 0 comments

    SQL Code using CTE:

    with report as 
    (
    select
        name,
        grade,
        marks
    from students
    join grades
    on students.marks between grades.min_mark and grades.max_mark
    )
    select 
        case when grade>=8 then name
             else null end, 
        grade,
        marks
    from report
    order by grade desc, name;