SQLite Exercise: Display the last names of employees having 'e' as the third character
Write a query to display the last names of employees having 'e' as the third character.
Sample table : employees
SQLite Code :
SELECT last_name FROM employees WHERE last_name LIKE '__e%';
last_name ---------- Greenberg Chen Gee McEwen Greene Lee Ozer Abel Fleaur Everett Feeney Baer Gietz
Sqlite Online Editor
Structure of 'hr' database :
Improve this sample solution and post your code through Disqus.
What is the difficulty level of this exercise?