OCP CBT Question 649

Please solve the following question.

Which SQL statement will retrieve the `first_name`, `last_name`, and `email` for all employees whose `last_name` starts with 'Sm'?

sqlSELECT first_name, last_name, email FROM employees;

EMPLOYEES Table Sample Data

SELECT first_name, last_name, email FROM employees WHERE last_name = 'Sm%';

SELECT first_name, last_name, email FROM employees WHERE last_name LIKE '%Sm';

SELECT first_name, last_name, email FROM employees WHERE last_name LIKE 'Sm%';

SELECT first_name, last_name, email FROM employees WHERE last_name STARTS WITH 'Sm';