7 kyu

SQL Basics: Repeat and Reverse

10,785 of 10,787PG1

Description:

Using our monsters table with the following schema:

monsters table schema

  • id
  • name
  • legs
  • arms
  • characteristics

return the following table:

** output schema**

  • name
  • characteristics

Where the name is the original string repeated three times (do not add any spaces), and the characteristics are the original strings in reverse (e.g. 'abc, def, ghi' becomes 'ihg ,fed ,cba').

Fundamentals
SQL

More By Author:

Check out these other kata created by PG1

Stats:

CreatedJun 14, 2017
PublishedJun 14, 2017
Warriors Trained15900
Total Skips1494
Total Code Submissions27361
Total Times Completed10787
SQL Completions10785
Total Stars49
% of votes with a positive feedback rating89% of 1145
Total "Very Satisfied" Votes926
Total "Somewhat Satisfied" Votes186
Total "Not Satisfied" Votes33
Total Rank Assessments13
Average Assessed Rank
7 kyu
Highest Assessed Rank
6 kyu
Lowest Assessed Rank
8 kyu
Ad
Contributors
  • PG1 Avatar
  • smile67 Avatar
Ad