Given the following table :

Table : STUDENT

No.	Name	Stipend	Stream	AvgMark	Grade	Class
1	Karan	400.00	Medical	78.5	B	12B
2	Divakar	450.00	Commerce	89.2	A	11C
3	Divya	300.00	Commerce	68.6	C	12C
4	Arun	350.00	Humanities	73.1	B	12C
5	Sabina	500.00	Nonmedical	90.6	A	11A
6	John	400.00	Medical	75.4	B	12B
7	Robert	250.00	Humanities	64.4	C	11A
8	Rubina	450.00	Nonmedical	88.5	A	12A
9	Vikas	500.00	Nonmedical	92.0	A	12A
10	Mohan	300.00	Commerce	67.5	C	12C

Give the output of following SQL statements :

1. SELECT MIN(AvgMark) FROM STUDENT WHERE AvgMark < 75 ;
2. SELECT SUM(Stipend) FROM STUDENT WHERE Grade = 'B' ;
3. SELECT AVG(Stipend) FROM STUDENT WHERE Class = '12A' ;
4. SELECT COUNT(DISTINCT) FROM STUDENT ;

1.

Output

+--------------+
| MIN(AvgMark) |
+--------------+
| 64.4         |
+--------------+

2.

Output

+--------------+
| SUM(Stipend) |
+--------------+
|         1150 |
+--------------+

3.

Output

+--------------+
| AVG(Stipend) |
+--------------+
|          475 |
+--------------+

4. It will give an error because the COUNT function requires an argument specifying what to count. Additionally, the DISTINCT keyword is followed by a column name to count the distinct values of that column.