Give the output of following SQL statements: SELECT COUNT (DISTINCT SPORTS) FROM Club;

Q.

 

 

Give the output of following SQL statements:

(i) SELECT COUNT (DISTINCT SPORTS) FROM Club;

(ii) SELECT MIN(Age) FROM CLUB WHERE Sex = 'F';

(iii) SELECT AVG(Pay) FROM CLUB WHERE Sports = 'KARATE' ;

(iv) SELECT SUM(Pay) FROM CLUB WHERE Datofapp > '31/01/98'

Answer :-

(i)

 

COUNT (DISTINCT SPORTS)

4

(ii)

 

MIN(Age)

34

 

(iii)

 

AVG(Pay)

1100

 

(iv)

 

SUM(Pay)

7800