Write SQL commands for the following on the basis of given table GRADUATE (a) List the names of those students who have

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

(a) List the names of those students who have obtained Rank 1 sorted by NAME.

(b) Display a report, listing NAME, STIPEND, SUBJECT and amount of stipend received in a year assuming that the STIPEND is paid every month.

Answer  =

(a)
Select name from GRADUATE
Where Rank = 1
Order by NAME ;

(b)
Select name ,stipend , subject , stipend * 12 as stipend_in_year  from  graduate ;