SQLite：

select last_name ||"'"|| first_name from employees;

MySQL:

select concat(last_name,"'", first_name) from employees;