SELECT first_name || ' ' || last_name 
as name
from copywriter

----- other db
SELECT CONCAT(first_name,' ',last_name) AS name
FROM copywriter;