CODE EXAMPLE FOR SQL

query concatenate

SELECT CONCAT(first_name, ' ', last_name) AS 'Name', dept FROM users;