Higher Than 75 Marks

  • + 3 comments

    select name from students where marks>75 order by substr((name),-3,3),ID asc;

    **It is not necessary to keep ID in select condition.