F List the Phone and FirstName of all customers whose last n

F. List the Phone and FirstName of all customers whose last name includes the characters, \'cat\'.

Solution

Answer:

select phone, firstname from customer where lastname like \'%cat%\';

this query will pull the records of all customers whose last name includes the characters, \'cat\'.