Which query returns all records that contain the character ‘z’ from the name column in the employees table?

Tools of the Trade: Linux and SQL | Weekly challenge 4 Quiz | 

Which query returns all records that contain the character ‘z’ from the name column in the employees table?

• SELECT name FROM employees WHERE name = ‘z%’;
• SELECT name FROM employees WHERE name LIKE ‘z’;
• SELECT name FROM employees WHERE name LIKE ‘%z’;
• SELECT name FROM employees WHERE name LIKE ‘%z%’;