8 kyu
SQL Basics: Simple DISTINCT
23,294 of 23,298matt c
Description:
For this challenge you need to create a simple DISTINCT statement, you want to find all the unique ages.
people table schema
- id
- name
- age
select table schema
- age (distinct)
NOTE: Your solution should use pure SQL. Ruby is used within the test cases to do the actual testing.
SQL
Fundamentals
Similar Kata:
Stats:
| Created | Oct 26, 2016 |
| Published | Oct 26, 2016 |
| Warriors Trained | 25643 |
| Total Skips | 926 |
| Total Code Submissions | 31612 |
| Total Times Completed | 23298 |
| SQL Completions | 23294 |
| Total Stars | 46 |
| % of votes with a positive feedback rating | 88% of 2118 |
| Total "Very Satisfied" Votes | 1698 |
| Total "Somewhat Satisfied" Votes | 341 |
| Total "Not Satisfied" Votes | 79 |
| Total Rank Assessments | 10 |
| Average Assessed Rank | 7 kyu |
| Highest Assessed Rank | 7 kyu |
| Lowest Assessed Rank | 8 kyu |
