Select last_name, first_name from employees; select last_name, first_name from employees; select last_name from employees

Topic describes

Answer key

We will focus on string concatenation

sqlite

SELECT (last_name || ' ' || first_name) AS Name FROM employees;
Copy the code

MySQL:

SELECT CONCAT_WS(' ', last_name, first_name) AS Name FROM employees;
Copy the code