Give the output of following SQL statement: (i) SELECT MIN(AvgMark) FROM STUDENT WHERE AvgMark

Q. Give the following table:-

Give the output of following SQL statements :

(i) SELECT MIN(AvgMark) FROM STUDENT WHERE AvgMark < 75 ;

(ii) SELECT SUM(Stipend) FROM Student WHERE Grade = 'B' ;

(iii) SELECT AVG(Stipend) FROM Student WHERE Class = '12A' ;

(iv) SELECT COUNT(DISTINCT) FROM Student ;

Answer :-

(i)

MIN(AvgMark

64.40

(ii)

SUM(Stipend)

1150.00

(iii)

AVG(Stipend)

475.00

(iv)

It will give an error.