Question

(c) Given the following table:
Stipend
Grasle
Name
Karan
Divakar
Divya
Table: Student
Stream
AvgMark
Medical
78.5
Commerce
89.2
Commerce
68.6
Humanities
73.1
Non Medical
Medical
C
B
450
300
350
500
100
250
450
500
300
Sabina
John
c
12A
Rubina
Vikas
Mohan
Non Medical
Non Medical
Commerce
67.5
120
Write the SQL queries for ) to (iv) and give the output of the SQL statements to vi
(1) Display name, grade and stream for those students getting average marks less than
Display stipend and avgmarks grade wise.
Display name, class and stipend for those students whose stream is commerce
(iv)
Display the names and stipend of student in the descending order of grade
(v)
SELECT sum(stipend) from student where Grade = "C";
(vi)
SELECT count(distinct grade) from student;
(vii) SELECT avg(stipend) from student where Grade = 'A':
(viii) SELECT max(stipend), min(AvgMark) from student:​

Answer 1

Answer:

PLZ SUBSCRIBE MY YOUTUBE CHANNEL KEVIN GAMING LOGO IS OF EAGLE