Question

Consider the table CLUB given below and write the output of the SQL queries that follow.

CID	CNAME	AGE	GENDER	SPORTS	PAY	DOAPP
5246	AMRITA	35	FEMALE	CHESS	900	2006- 03-27
4687	SHYAM	37	MALE	CRICKET	1300	2004- 04-15
1245	MEENA	23	FEMALE	VOLLEYBALL	1000	2007- 06-18
1622	AMRIT	28	MALE	KARATE	1000	2007- 09-05
1256	AMINA	36	FEMALE	CHESS	1100	2003- 08-15
1720	MANJU	33	FEMALE	KARATE	1250	2004- 04-10
2321	VIRAT	35	MALE	CRICKET	1050	2005- 04-30

1. SELECT COUNT(DISTINCT SPORTS) FROM CLUB;
2. SELECT CNAME, SPORTS FROM CLUB
   WHERE DOAPP<"2006-04-30" AND CNAME LIKE "%NA";
3. SELECT CNAME, AGE, PAY FROM CLUB WHERE GENDER = "MALE" AND PAY BETWEEN 1000 AND 1200;

Answer 1

1. 
   

   COUNT(DISTINCT SPORTS)

   4

2. 
   

   CNAME	SPORTS
   AMINA	CHESS

3. 
   

   CNAME	AGE	PAY
   AMRIT	28	1000
   VIRAT	35	1050