7 kyu

SQL: Right and Left

7,553 of 7,554PG1

Description:

You are given a table named repositories, format as below:

** repositories table schema **

  • project
  • commits
  • contributors
  • address

The table shows project names of major cryptocurrencies, their numbers of commits and contributors and also a random donation address ( not linked in any way :) ).

For each row: Return first x characters of the project name where x = commits. Return last y characters of each address where y = contributors.

Return project and address columns only, as follows:

** output table schema **

  • project
  • address

Case should be maintained.

Fundamentals
SQL

More By Author:

Check out these other kata created by PG1

Stats:

CreatedJun 16, 2017
PublishedJun 16, 2017
Warriors Trained13698
Total Skips1619
Total Code Submissions31610
Total Times Completed7554
SQL Completions7553
Total Stars88
% of votes with a positive feedback rating87% of 890
Total "Very Satisfied" Votes703
Total "Somewhat Satisfied" Votes151
Total "Not Satisfied" Votes36
Total Rank Assessments28
Average Assessed Rank
7 kyu
Highest Assessed Rank
5 kyu
Lowest Assessed Rank
8 kyu
Ad
Contributors
  • PG1 Avatar
  • Voile Avatar
  • LeMagnifiq Avatar
Ad