Skip to content

Latest commit

 

History

History
24 lines (15 loc) · 424 Bytes

SQL-Concatenating-Columns.md

File metadata and controls

24 lines (15 loc) · 424 Bytes

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.

/*  SQL  */
select CONCAT  (prefix, ' ', first, ' ', last, ' ', suffix) AS title FROM names