Write SQL commands for the following on the basis of given table STUDENT1 Select all the Nonmedical stream students from STUDENT1.

Q.Write SQL commands for the following on the basis of given table STUDENT1 :

(a) Select all the Nonmedical stream students from STUDENT1.

(b) List the names of those students who are in class 12 sorted by Stipend.

(c) List all students sorted by AvgMark in descending order.

(d) Display a report, listing Name, Stipend, Stream and amount of stipend received in a year assuming that the Stipend is paid every month.

Answer =

a.
select * from student1
where stream = “Nonmedical” ;

b.
select name from student1
where class like “12%”
order by stipend ;

c.
select * from student1
order by AvgMark desc;

d.
select name , stipend , stream , stipend * 12 as stipend_in_year from student1 ;