8 kyu
SQL Basics: Simple MIN / MAX
21,971 of 21,974matt 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 | 25431 |
| Total Skips | 1059 |
| Total Code Submissions | 46734 |
| Total Times Completed | 21974 |
| SQL Completions | 21971 |
| Total Stars | 58 |
| % of votes with a positive feedback rating | 90% of 2189 |
| Total "Very Satisfied" Votes | 1823 |
| Total "Somewhat Satisfied" Votes | 308 |
| Total "Not Satisfied" Votes | 58 |
| Total Rank Assessments | 8 |
| Average Assessed Rank | 8 kyu |
| Highest Assessed Rank | 8 kyu |
| Lowest Assessed Rank | 8 kyu |
