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
Similar Kata:
Stats:
Created | Jun 16, 2017 |
Published | Jun 16, 2017 |
Warriors Trained | 17858 |
Total Skips | 1106 |
Total Code Submissions | 37274 |
Total Times Completed | 14119 |
SQL Completions | 14118 |
Total Stars | 62 |
% of votes with a positive feedback rating | 90% of 1425 |
Total "Very Satisfied" Votes | 1175 |
Total "Somewhat Satisfied" Votes | 219 |
Total "Not Satisfied" Votes | 31 |
Total Rank Assessments | 60 |
Average Assessed Rank | 7 kyu |
Highest Assessed Rank | 4 kyu |
Lowest Assessed Rank | 8 kyu |