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

Q. Given 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 ;

Consider  this table --

Answer = 

(i)

MIN(AvgMark)

64.40

(ii)

SUM(Stipend)

1150.00

(iii)

AVG(Stipend)

475.00

(iv)

 

ERROR 

Because there is no field name in count function.