Write SQL commands for the following in the basis of given table STUDENT.

(a) Select all the Nonmedical stream students from STUDENT1.
(b) List the name of those students who are in class 12 sorted by Stipend.
(c) List all student sorted by AvgMark in descending order.

Ans:

(a) SELECT * FROM STUDENT WHERE STREAM = “Nonmedical”;

(b) SELECT NAME FROM STUDENT WHERE CLASS LIKE “12%” ORDER BY STIPEND;

(c) SELECT * FROM STUDENT ORDER BY AVGMARKS DESC;