Consider the table given below:
Table : STUDENT
| ADMNO | NAME | CLASS | SCORE |
| A001 | Amit | 12A | 90 |
| A002 | Amit | 12B | 91 |
| A003 | Bhavana | 12A | 90 |
| A004 | Yamini | 12A | 89 |
| A005 | Ashok | 12B | 95 |
Using the STUDENT table, you want to select all records where the CLASS is either '12A' or '12B'. Which of the following SQL commands correctly achieves this?
A. SELECT * FROM STUDENT WHERE CLASS = '12A' OR CLASS = '12B';
B. SELECT * FROM STUDENT WHERE CLASS IN ('12A', '12C');
C. SELECT * FROM STUDENT WHERE CLASS IN ('12A', '12B');
D. SELECT * FROM STUDENT WHERE CLASS = '12A' AND '12B';
1
Only A and D
2
Only B and C
3
Only A and C
4
All of the above