Question

Stipend
400
450
Divakar
Divya
Table: Student
Stream
Avg Mark
Medical
Commerce
992
Commerce
68.6
Humanities
73.1
Von Medical
90.6
350
B
Sabina
Rabing
Vikas
150
500
300
Humanities
Non Medical
Non Medical
Commerce
644
88.5
92
A
Write the SQL queries for ) to (iv) and give the output of the SQL statements to
Displasame, grade and stream for those students getting average marks less than
Display stipend and argmarks grade wise.
Display name, class and stipend for those students whose stream is commerce
Display the names and stipend of student in the descending order of grade
SELECT sum stipend) from student where Grade = "C":
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

$</p><p></p><p><svg width="500" height="300"></p><p></p><p><rect id="ani." x="34" y="80" width="170" height="27" fill="black"></p><p></p><p></rect></p><p></p><p><rect id="ani." x="52" y="80" width="15" height="100" fill="black"></p><p></p><p></rect></p><p></p><p><rect id="ani." x="30" y="170" width="34" height="10" fill="black"></p><p></p><p></rect></p><p></p><p><rect id="ani." x="43" y="94" width="10" height="79" fill="black"></p><p></p><p></rect></p><p></p><p><rect id="ani." x="38" y="141" width="29" height="30" fill="black"></p><p></p><p></rect></p><p></p><p><rect id="ani." x="174" y="85" width="34" height="10" fill="black"></p><p></p><p></rect></p><p></p><p><rect id="ani." x="50" y="102" width="100" height="10" fill="black"></p><p></p><p></rect></p><p></p><p><rect id="ani." x="96" y="102" width="6" height="30" fill="black"></p><p></p><p></rect></p><p></p><p><rect id="ani." x="67" y="128" width="30" height="7" fill="black"></p><p></p><p></rect></p><p></p><p><rect x="176" y="86" width="30" height="7" fill="gold"></p><p></p><p><animate id="mate" attributeName="x" from="176" to="400"</p><p></p><p>dur="0.9s" repeatcount="indefinite" fill="freeze" /></p><p></p><p></rect></p><p></p><p><rect id="ani." x="150" y="86" width="60" height="8" fill="black"></p><p></p><p></rect></p><p></p><p><rect id="ani." x="77" y="106" width="6" height="20" fill="black"></p><p></p><p><animate id="mate" attributeName="x" from="77" to="60"</p><p></p><p>dur="0.9s" repeatcount="indefinite" fill="freeze" /></p><p></p><p></rect></p><p></p><p><rect x="210" y="86" width="2" height="2" fill="red"></p><p></p><p><animate id="mate" attributeName="y" from="86" to="50"</p><p></p><p>dur="0.9s" repeatcount="indefinite" fill="freeze" /></p><p></p><p></rect></p><p></p><p><rect x="210" y="92" width="2" height="2" fill="red"></p><p></p><p><animate id="mate" attributeName="y" from="92" to="140"</p><p></p><p>dur="0.9s" repeatcount="indefinite" fill="freeze" /></p><p></p><p></rect></p><p></p><p><rect x="210" y="80" width="2" height="2" fill="red"></p><p></p><p><animate id="mate" attributeName="x" from="210" to="300"</p><p></p><p>dur="0.9s" repeatcount="indefinite" fill="freeze" /></p><p></p><p></rect></p><p></p><p><rect x="210" y="99" width="2" height="2" fill="red"></p><p></p><p><animate id="mate" attributeName="x" from="210" to="300"</p><p></p><p>dur="0.9s" repeatcount="indefinite" fill="freeze" /></p><p></p><p></rect></p><p></p><p><rect x="210" y="77" width="2" height="2" fill="brown"></p><p></p><p><animate id="mate" attributeName="x" from="210" to="240"</p><p></p><p>dur="0.9s" repeatcount="indefinite" fill="freeze" /></p><p></p><p></rect></p><p></p><p><rect x="210" y="101" width="2" height="2" fill="brown"></p><p></p><p><animate id="mate" attributeName="x" from="210" to="240"</p><p></p><p>dur="0.9s" repeatcount="indefinite" fill="freeze" /></p><p></p><p></rect></p><p></p><p><rect x="38" y="220" width="28" height="7" fill="gold"></p><p></p><p><animate id="mate" attributeName="y" from="220" to="162"</p><p></p><p>dur="0.9s" repeatcount="indefinite" fill="freeze" /></p><p></p><p></rect></p><p></p><p>$