A database table is defined as students(id, name, marks). Which of the following SQL queries correctly lists the names of all students who scored more than 75 marks, arranged from the highest scorer to the lowest scorer?
SELECT name FROM students WHERE marks > 75 ORDER BY marks DESC;
SELECT name FROM students WHERE marks > 75 ORDER BY marks ASC;
SELECT name FROM students HAVING marks > 75 ORDER BY marks DESC;
SELECT name FROM students WHERE marks > 75 GROUP BY marks;
The verified answer and full solution are one login away
Every answer here is machine verified, with a step-by-step solution that teaches the method. Your login also unlocks a 7-question mock preview in the real exam interface.
Log in to see the answerMore sql questions