8 kyu
SQL Basics: Simple MIN / MAX
21,646 of 21,649matt c
Description:
For this challenge you need to create a simple MIN / MAX statement that will return the Minimum and Maximum ages out of all the people.
people table schema
- id
- name
- age
select table schema
- age_min (minimum of ages)
- age_max (maximum of ages)
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 | 25061 |
| Total Skips | 1040 |
| Total Code Submissions | 46073 |
| Total Times Completed | 21649 |
| SQL Completions | 21646 |
| Total Stars | 58 |
| % of votes with a positive feedback rating | 90% of 2169 |
| Total "Very Satisfied" Votes | 1807 |
| Total "Somewhat Satisfied" Votes | 304 |
| Total "Not Satisfied" Votes | 58 |
| Total Rank Assessments | 8 |
| Average Assessed Rank | 8 kyu |
| Highest Assessed Rank | 8 kyu |
| Lowest Assessed Rank | 8 kyu |
