The Report

  • + 0 comments

    **Solution is without using JOIN ** WITH GRADES AS (SELECT *, CASE WHEN Marks<=89 THEN FLOOR(cast((Marks/10) as decimal(10,2)))+1 ELSE 10 END GRADE
    FROM STUDENTS) SELECT CASE WHEN GRADES.GRADE >=8 THEN NAME ELSE "NULL" END, GRADE, MARKS FROM GRADES ORDER BY GRADE DESC, NAME, MARKS