Higher Than 75 Marks

  • + 0 comments

    In the above code why can not we use 'and' before 'ID ASC;' whats wrong in the below mentioned code??

    SELECT NAME FROM STUDENTS WHERE MARKS > 75 ORDER BY RIGHT(NAME, 3) and ID ASC;