Question

14. Write SQL commands for the following on the basis of given table STUDENTI :
Table : STUDENT1
No.1
Name karan
Grade B
Karan
AvgMark 78.5
78.5
89.2
Class
12B
a un to w Nw
110
12C
Divakar
Divya
Arun
Sabina
John
Robert
Rubina
Vikas
Mohan
Stipend
400.00
450.00
300.00
350.00
500.00
400.00
250.00
450.00
500.00
300.00
Stream
Medical
Commerce
Commerce
Humanities
Nonmedical
Medical
Humanities
Nonmedical
Nonmedical
Commerce
68.6
73.1
90.6
75.4
12C
11A
12B
11A
12A
12A
64.4
o oco
88.5
92.0
67.5
12C
(a) Select all the Nonmedical stream students from STUDENTI.
(b) List the names of those students who are in dass 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 1

Answer:

(a). select Name from STUDENTI where stream="Nonmedical";

(b). select Name from STUDENTI where class like "12%" order by Stipend;

(c).  select Name from STUDENTI order by AvgMark desc;

(d). select Name, Stipend, Stream, Stipend*12 as Yearly_Stipend from STUDENTI;

Explanation: