Q.Write an SQL query to display the Name and Marks of all students who belong to class 'XI-A' from the Student table.

This asks you to read back selected columns and selected rows, which needs SELECT with a column list and a WHERE condition. …

The SELECT statement reads data from a table. Two 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. Choosing rows: because only students of class XI-A are wanted, we add a WHERE clause with the condition Class = 'XI-A'. The text value XI-A is written inside single quotes.

The complete query is:

SELECT Name, Marks FROM Student
WHERE Class = 'XI-A';
``` …

To display all columns instead of just two, replace the column list with *: `SELECT …

Do not use SELECT * when only some columns are asked for — name the required columns. Remember the single quotes around the text value in the WHERE condition (Clas …