7 kyu

SQL: Right and Left

7,686 of 7,687PG1

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 Trained13898
Total Skips1628
Total Code Submissions32134
Total Times Completed7687
SQL Completions7686
Total Stars91
% of votes with a positive feedback rating87% of 898
Total "Very Satisfied" Votes709
Total "Somewhat Satisfied" Votes153
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