7 kyu
BASICS: Length based SELECT with LIKE
10,611 of 10,613baaart
Description:
You will need to create SELECT statement in conjunction with LIKE.
Please list people which have first_name with at least 6 character long
names table schema
- id
- first_name
- last_name
results table schema
- first_name
- last_name
Fundamentals
SQL
Databases
Similar Kata:
Stats:
| Created | Feb 21, 2018 |
| Published | Feb 21, 2018 |
| Warriors Trained | 13755 |
| Total Skips | 927 |
| Total Code Submissions | 31056 |
| Total Times Completed | 10613 |
| SQL Completions | 10611 |
| Total Stars | 48 |
| % of votes with a positive feedback rating | 85% of 1091 |
| Total "Very Satisfied" Votes | 839 |
| Total "Somewhat Satisfied" Votes | 187 |
| Total "Not Satisfied" Votes | 65 |
| Total Rank Assessments | 5 |
| Average Assessed Rank | 7 kyu |
| Highest Assessed Rank | 7 kyu |
| Lowest Assessed Rank | 8 kyu |
