Consider the table STUDENT given below and write the output of the SQL queries that follow.
SID |
SNAME |
MARKS |
GRADE |
SECTION |
101 |
RAVI |
85 |
A |
1 |
102 |
PRIYA |
90 |
A |
2 |
103 |
RAJU |
75 |
B |
1 |
104 |
ANITA |
80 |
B |
2 |
105 |
RANI |
70 |
C |
1 |
106 |
RAHUL |
65 |
C |
2 |
107 |
RAMESH |
95 |
A |
1 |
108 |
PREETI |
60 |
D |
2 |
(i) SELECT AVG(MARKS) FROM STUDENT WHERE GRADE = "A";
Answer:
Answer by student
The output of the SQL query is:
|
AVG(MARKS) |
|
90 |
Detailed answer by teachoo
The rest of the post is locked. Join Teachoo Black to see the full post.
