Codewars Kata SQL

SQL: Concatenating Columns

Given the table below:

** names table schema **

• id
• prefix
• first
• last
• suffix

Your task is to use a select statement to return a single column table containing the full title of the person (concatenate all columns together except id), as follows:

** output table schema **

• title

Don’t forget to add spaces.

Solution:

SELECT concat(prefix, ' ', first, ' ', last, ' ', suffix) as title FROM names;

Link