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

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

(ii) SELECT CNAME, SPORTS FROM CLUB WHERE DOAPP<"2006-04-30" AND CNAME LIKE "%NA";

(iii) SELECT CNAME, AGE, PAY FROM CLUB WHERE GENDER = "MALE" AND PAY BETWEEN 1000 AND 1200;

Output

(i)

+------------------------+
| COUNT(DISTINCT SPORTS) |
+------------------------+
|                      4 |
+------------------------+

(ii)

+-------+--------+
| CNAME | SPORTS |
+-------+--------+
| AMINA | CHESS  |
+-------+--------+

(iii)

+-------+-----+------+
| CNAME | AGE | PAY  |
+-------+-----+------+
| AMRIT |  28 | 1000 |
| VIRAT |  35 | 1050 |
+-------+-----+------+