The Report

  • + 0 comments

    I made some changes, I thint this is more clear. The only issue with this question is the order by. Thx for explaining decode.

    select (case when grade <8 THEN NULL ELSE name END) name, grade, marks
    from students,grades
    where marks between min_Mark and Max_Mark
    order by grade desc, name, decode(name,NULL,marks);