Objective

Write a SQL query to retrieve the full names of all employees by combining their first and last names. The result should include a single column named full_name, which is the concatenation of first_name and last_name separated by a space. The output should be ordered alphabetically by full_name.

Additional information

• Table Name: employees
• Table Schema:

• Output: A list of objects with a single key full_name.
• Constraints:
  • Ensure that full_name correctly combines first_name and last_name with a space in between.
  • The results must be sorted in ascending order based on full_name.

SELECT CONCAT(first_name, ' ', last_name) AS full_name
FROM employees
ORDER BY full_name;

Explanation

Step 1: Concatenate first and last names with a space

CONCAT(first_name, ' ', last_name) merges the two name columns into a single string with a space separator between them, e.g., 'Jane' + ' ' + 'Doe' = 'Jane Doe'.

SELECT CONCAT(first_name, ' ', last_name) AS full_name

Step 2: Sort results alphabetically by full name

ORDER BY full_name sorts the concatenated names in ascending alphabetical order.

ORDER BY full_name;