Higher Than 75 Marks

  • + 0 comments

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

    at last id ASC we wirte used to In case there are multiple students with the same last three characters in their names