We use cookies to ensure you have the best browsing experience on our website. Please read our cookie policy for more information about how we use cookies.
  1. Prepare
  2. SQL
  3. Basic Select
  4. Higher Than 75 Marks
  5. Discussions

Higher Than 75 Marks

  • rentdue
     + 0 comments
    /*
Enter your query here.
Please append a semicolon ";" at the end of the query and enter your query in a single line to avoid error.

simply take the STUDENTS table check for Marks > 75 in WHERE clause
then sort by order of last 3 chars and then id
*/

select Name 
from STUDENTS 
where Marks > 75
order by right(Name,3), ID;