Computer Science
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;
Answer
Output
(i)
+------------------------+
| COUNT(DISTINCT SPORTS) |
+------------------------+
| 4 |
+------------------------+
(ii)
+-------+--------+
| CNAME | SPORTS |
+-------+--------+
| AMINA | CHESS |
+-------+--------+
(iii)
+-------+-----+------+
| CNAME | AGE | PAY |
+-------+-----+------+
| AMRIT | 28 | 1000 |
| VIRAT | 35 | 1050 |
+-------+-----+------+
Related Questions
Predict the output of the following code:
def Changer(P, Q = 10): P = P / Q Q = P % Q return P A = 200 B = 20 A = Changer(A, B) print(A, B, sep = '$') B = Changer(B) print(A, B, sep = '$', end = '###')Predict the output of the Python code given below:
Text1 = "IND-23" Text2 = "" I = 0 while I < len(Text1): if Text1[I] >= "0" and Text1[I] <= "9": Val = int(Text1[I]) Val = Val + 1 Text2 = Text2 + str(Val) elif Text1[I] >= "A" and Text1[I] <= "Z": Text2 = Text2 + (Text1[I + 1]) else: Text2 = Text2 + "*" I += 1 print(Text2)Write a function in Python to read a text file, Alpha.txt and displays those lines which begin with the word ‘You’.
Write a function, vowelCount() in Python that counts and displays the number of vowels in the text file named Poem.txt.