Q.Using the Student table, write SQL queries to

This tests two useful WHERE operators: BETWEEN for a range of values, and LIKE with a wildcard for a text pattern.

Both queries use SELECT ... WHERE, each with a different operator.

(i) A range of values — BETWEEN: the BETWEEN operator tests whether a value lies within a range, with both ends included. For marks from 70 to 85:

SELECT Name FROM Student
WHERE Marks BETWEEN 70 AND 85;

This is the same as writing WHERE Marks >= 70 AND Marks <= 85, but shorter and clearer.

(ii) A text pattern — LIKE: the LIKE operator matches text against a pattern using wildcards. The wildcard % stands for any number of characters (including none). To find names beginning with the letter A:

SELECT Name FROM Student
WHERE Name LIKE 'A%';
``` …

For the range, an equivalent query without BETWEEN is `SELECT Name FROM Student W …

Remember that BETWEEN includes both end values (70 and 85 are counted). With LIKE, keep the pattern in single quotes and use % for 'any characters' and _ for 'exactly one character' — …