[Answer] Satyam, a database analyst has created the following table: He has written following queries: ( a) select sum(MARKS) from student where OPTIONAL= ‘IP’ and STREAM= ‘Commerce’;

The Question : Satyam, a database analyst has created the following table:He has written following queries:

A) select sum(MARKS) from student where OPTIONAL= ‘IP’ and STREAM= ‘Commerce’;
B) select max(MARKS)+min(MARKS) from student where OPTIONAL= ‘CS’;
C) select avg(MARKS) from student where OPTIONAL= ‘IP’;
D) select length(SNAME) from student where MARKS is NULL;Help him in predicting the output of the above given queries.

Solution for the question :
Output: (a) 193 (b) 194 (c) 93.75 (d) 6

The correct answer to the question is researched by our moderators and shared with you. You can give feedback by commenting for the answers you think are wrong.