You need to display the last names of those employees who have the letter "A" as the second character in their names. Which SQL statement displays the required results? ()
- A SELECT last_name FROM EMP WHERE last_ name LIKE '_A%';
- B SELECT last_name FROM EMP WHERE last name ='*A%'
- C SELECT last_name FROM EMP WHERE last name ='_A%';
- D SELECT last_name FROM EMP WHERE last name LIKE '*A%'