We use cookies to ensure you have the best browsing experience on our website. Please read our cookie policy for more information about how we use cookies.
  1. Practice
  2. SQL
  3. Basic Join
  4. The Report
  5. Discussions

The Report

  • chenming0801 + 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);