8 kyu
SQL Basics: Simple DISTINCT
22,963 of 22,967matt 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 | 25279 |
| Total Skips | 913 |
| Total Code Submissions | 31200 |
| Total Times Completed | 22967 |
| SQL Completions | 22963 |
| Total Stars | 46 |
| % of votes with a positive feedback rating | 88% of 2108 |
| Total "Very Satisfied" Votes | 1692 |
| Total "Somewhat Satisfied" Votes | 338 |
| Total "Not Satisfied" Votes | 78 |
| Total Rank Assessments | 10 |
| Average Assessed Rank | 7 kyu |
| Highest Assessed Rank | 7 kyu |
| Lowest Assessed Rank | 8 kyu |
