Q.Write an SQL query to display the Name and Marks of all students of class 'XI-A' whose Marks are greater than 75, from the Student table.

This asks you to read back selected columns and rows using SELECT with a WHERE clause that combines two conditions. …

The SELECT statement reads data from a table. Three things are needed here:

1. Choosing columns: because only Name and Marks are wanted (not every column), we name those two columns after SELECT instead of using *.
2. Filtering rows: we add a WHERE clause. There are two conditions — the class must be XI-A, and the marks must be greater than 75.
3. Combining conditions: because both must be true, we join them with the logical operator AND. The comparison Marks > 75 uses the greater-than operator, and the text value 'XI-A' is written in single quotes.

The complete query is:

If either condition (not necessarily both) should be enough, replace AND with OR: `SELECT Name, Marks FROM …

Use AND when both conditions must hold and OR when either is enough — mixing them up is a very common error. Remember the single quotes around the text value ('XI-A', not …