Full Name Formatting - Easy SQL String Functions Interview Problem

Problem

A company HR report needs each employee's full name displayed as a single string rather than two separate columns. Using the employees table, return id, full_name (first and last name separated by a space), and department. Sort by last_name.

Schema

employees

column	type
id	INTEGER
first_name	TEXT
last_name	TEXT
department	TEXT

Sample Data

id	first_name	last_name	department
1	Alice	Chen	Engineering
2	Bob	Adams	Marketing
3	Carol	Zheng	HR

Expected Output

id	full_name	department
2	Bob Adams	Marketing
1	Alice Chen	Engineering
3	Carol Zheng	HR

Explanation

First name and last name are joined with a single space using string concatenation. Results are ordered alphabetically by last name.

Hints