The Report

  • + 0 comments

    Without Using Join

    select 
    case  
        when marks>=70 then name
        else null
        end as Name,
    case 
     when marks=100 then 10
     else floor((marks/10)+1)
     end as grade, marks
    from Students
    order by grade desc,name;
    # **