List the names of those students who have obtained DIV I sorted by NAME. 2. Display a report, listing NAME,...

1. List the names of those students who have obtained DIV I sorted by NAME.
2. Display a report, listing NAME, STIPEND, SUBJECT and amount of stipend received in a year assuming that the STIPEND is paid every month.
3. To count the number of students who are either PHYSICS or COMPUTER SC graduates.
4. To insert a new row in the GRADUATE table: 11, "KAJOL", 300, "computer sc", 75, 1
(B) Give the output of following sql statement based on the above table
1. Select MIN(AVERAGE) from GRADUATE where SUBJECT="PHYSICS";
2. Select SUM(STIPEND) from GRADUATE WHERE div=2;