How to get all records from a table, which contains letter 'a' in their names?

Question

How to get all records from a table "employee", which contains letter 'a' in their last names? this the question in recruitment test i came across with, as far as i know there is no last name and first name,it is a single name like King,John etc But nevertheless how v can write its query?

Answer 1

Try this