Based on the following CLUB table, which SQL query will give the number of…
2017
Based on the following CLUB table, which SQL query will give the number of MONTHLY members who joined after 01-JAN-2007?
CLUB
MNO | NAME | FEE | TYPE | DOJ
1001 | ARUNA ZAIDI | 150000 | LIFE | 30/JAN/08
1010 | KANIKA SEN | 5000 | MONTHLY | 12/JUN/05
1015 | TARIK AZAAD | 30000 | ANNUAL | 23/MAR/15
1003 | RAVI THAKUR | 5500 | MONTHLY | 14/APR/12
1002 | MANAV SINGH | 30000 | ANNUAL | 15/OCT/12
1012 | GARGI JHA | 30000 | ANNUAL | 05/DEC/05
1009 | TANIK BHOLA | 120000 | LIFE | 01/JAN/05
1008 | BANTA GEORGE | 1000 | GUEST | 16/SEP/16
1014 | ALIYA DAGA | 5000 | MONTHLY | 15/SEP/10
- A.
SELECT , COUNT() FROM CLUB WHERE TYPE = 'MONTHLY' AND DOJ >= '01-JAN-07';
- B.
SELECT FROM CLUB COUNT() WHERE TYPE = 'MONTHLY' AND DOJ > '01-JAN-07';
- C.
SELECT COUNT() FROM CLUB WHERE TYPE = 'MONTHLY' OR DOJ = '01-JAN-07';
- D.
SELECT COUNT(*) FROM CLUB WHERE TYPE = 'MONTHLY' AND DOJ > '01-JAN-07';
Attempted by 1420 students.
Show answer & explanation
Correct answer: D
Correct answer: D. SELECT COUNT(*) FROM CLUB WHERE TYPE = 'MONTHLY' AND DOJ > '01-JAN-07';
From the table, MONTHLY members are KANIKA SEN (12/JUN/05), RAVI THAKUR (14/APR/12), and ALIYA DAGA (15/SEP/10). After 01-JAN-2007, the qualifying MONTHLY members are RAVI THAKUR and ALIYA DAGA, so the count is 2. COUNT(*) is required; COUNT() is invalid in standard SQL, and AND is required because both conditions must be true.