Give the output SELECT COUNT (DISTINCT SPORTS) FROM Club;

Q. Given the following table :

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’ ;

Consider  this table --

You can understand by seeing this video ---

 

 

Answer = 

(i)

COUNT (DISTINCT SPORTS)

4

  

(ii)

 

MIN(Age)

34

 

 

 

(iii)

 

AVG(Pay)

1100.0

  

(iv)

SUM(Pay)

7800