--Table names has columns prefix, first, last & suffix.
--Conctenate these column values an output it as title

SELECT concat_ws(' ', prefix,first,last,suffix) AS title FROM names;

select prefix || ' ' || first || ' '|| last || ' ' || suffix as title from names;