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
Similar Kata:
Stats:
Created | Jun 16, 2017 |
Published | Jun 16, 2017 |
Warriors Trained | 13698 |
Total Skips | 1619 |
Total Code Submissions | 31610 |
Total Times Completed | 7554 |
SQL Completions | 7553 |
Total Stars | 88 |
% of votes with a positive feedback rating | 87% of 890 |
Total "Very Satisfied" Votes | 703 |
Total "Somewhat Satisfied" Votes | 151 |
Total "Not Satisfied" Votes | 36 |
Total Rank Assessments | 28 |
Average Assessed Rank | 7 kyu |
Highest Assessed Rank | 5 kyu |
Lowest Assessed Rank | 8 kyu |