7 kyu
BASICS: Length based SELECT with LIKE
10,749 of 10,751baaart
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 | 13916 |
| Total Skips | 937 |
| Total Code Submissions | 31357 |
| Total Times Completed | 10751 |
| SQL Completions | 10749 |
| Total Stars | 49 |
| % of votes with a positive feedback rating | 85% of 1095 |
| Total "Very Satisfied" Votes | 842 |
| Total "Somewhat Satisfied" Votes | 187 |
| Total "Not Satisfied" Votes | 66 |
| Total Rank Assessments | 5 |
| Average Assessed Rank | 7 kyu |
| Highest Assessed Rank | 7 kyu |
| Lowest Assessed Rank | 8 kyu |
