Higher Than 75 Marks

  • + 0 comments

    by default the clause "order by" is ascending so you could omit 'asc'

    SELECT name FROM students WHERE marks > 75 ORDER BY RIGHT(name,3), id