PostgreSQL Restricting and Sorting Data: Get the first name of the employee who holds the letter 'c' and 'e' in the first name

5. Write a query to get the first name of the employee who holds the letter 'c' and 'e' in the first name.

Sample Solution:

Code:

SELECT first_name 
FROM employees 
WHERE first_name LIKE '%c%' 
AND first_name LIKE '%e%';

Sample table: employees

Output:

pg_exercises=# SELECT first_name
pg_exercises-# FROM employees
pg_exercises-# WHERE first_name LIKE '%c%'
pg_exercises-# AND first_name LIKE '%e%';
 first_name
------------
 Bruce
 Michael
 Vance
 Michael
(4 rows)

Relational Algebra Expression:

Relational Algebra Tree:

Practice Online

Have another way to solve this solution? Contribute your code (and comments) through Disqus.

Previous: Write a query to display the name, including first_name and last_name and hire date for all employees who were hired in 1987.
Next: Write a query to display the last name, job, and salary for all those employees who hasn't worked as a Programmer or a Shipping Clerk, and not drawing the salary $4,500, $10,000, or $15,000.