7 kyu

SQL: Concatenating Columns

14,118 of 14,119PG1

Description:

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.

Fundamentals
Strings
SQL

Stats:

CreatedJun 16, 2017
PublishedJun 16, 2017
Warriors Trained17858
Total Skips1106
Total Code Submissions37274
Total Times Completed14119
SQL Completions14118
Total Stars62
% of votes with a positive feedback rating90% of 1425
Total "Very Satisfied" Votes1175
Total "Somewhat Satisfied" Votes219
Total "Not Satisfied" Votes31
Total Rank Assessments60
Average Assessed Rank
7 kyu
Highest Assessed Rank
4 kyu
Lowest Assessed Rank
8 kyu
Ad
Contributors
  • PG1 Avatar
  • Voile Avatar
  • trashy_incel Avatar
Ad