Question

Averare
Division
S.NO
1
Name
KARAN
ARMAN
FIRST
2
Table. EXAM
Stipend Subject
400
ENGLISH
68
6.80
MATHEMATICS 72
500
ACCOUNTS
200
INFORMATICS
400
HISTORY
550
GEOGRAPHY 45
13
JAVED
FIRST
SECOND
BISHAKHA
THIRD
SUGANDHA
SUPARNA
6
THIRD
O

(1)To list the names of those students, who have obtained Division as FIRST in ascendin
order of Name
(2)To display a report
listing Name, subject and
annual Stipend/received thpt the Stipen
column has mothly stipend.
(3)To count the number of students who have either Accounts or Informatics as subject.
(4)To insert a new row in the table EXAM.
6, Mohan" SOO, "English73. "SECOND
(5)SELECT AVG Stipend) FROM EXAM WHERE Division='THIRD
(6)SELECT COUNT(DISTINCT Subject FROM EXAM
​

Answer 1

Explanation:

oh bhai maro mujhe maro