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 execute a SQL query to find all records where the NAME starts with the letter "A". Which of the following SQL commands correctly accomplishes this?
1
SELECT * FROM STUDENT WHERE NAME LIKE 'A%';
2
SELECT * FROM STUDENT WHERE NAME = 'A%';
3
SELECT * FROM STUDENT WHERE NAME LIKE '%A';
4
SELECT * FROM STUDENT WHERE NAME LIKE 'A_';