Question

Gives the table 'Player' with the following columns :

Table : Player

| PCODE | POINTS |
| 1 | 50 |
| 2 | NULL |
| 3 | 40 |

Write the output of the following statements :

(i) SELECT AVG (POINTS) FROM Player;

(ii) SELECT COUNT (POINTS) FROM Player

Answer 1

(i) AVG(POINTS)/45

(ii) COUNT(POINTS)/2