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;

4 views

1 Answers

Output

(i) AVG (POINTS)

30

(ii) COUNT (POINTS)

2

4 views