The Report

  • + 3 comments

    if(..., ..., ...) statement will be better, i think

    select if(grade > 7, name, null), grade, marks 
    from students, grades 
    where marks between min_mark and max_mark 
    order by grade desc, name