Q.Write an SQL query to display the Name and Marks of all students, arranged in descending order of Marks, from the Student table.

This asks you to read two columns and sort the whole result from highest to lowest marks, which needs ORDER BY ... DESC. …

To sort the output of a SELECT statement we add the ORDER BY clause, naming the field to sort on. DESC gives descending order (highest first); ASC (the default) gives ascending order.

Here we want the Name and Marks of all students, sorted from the highest marks down, so:

1. Name the columns: SELECT Name, Marks.
2. Give the table: FROM Student.
3. Sort descending on marks: ORDER BY Marks DESC.

The complete query is:

SELECT Name, Marks FROM Student
ORDER BY Marks DESC;
``` …

To sort from lowest to highest instead, use ASC (or leave it out, since ascending is the default): `SELECT …

Do not forget DESC for descending order — without it the result sorts ascending (lowest first) by default. ORDER BY comes aft …