What will be the output of the following MySQL statement?

SELECT *
FROM employee
WHERE lname LIKE %t%f%n%;

A. All employees whose last name contain 't' in the second position

B. All employees whose last name contains 'f' in the fourth position

C. All employees whose last name contains 'n' in second last position

D. All of the mentioned

Answer: Option D