5 kyu
SQL Statistics: MIN, MEDIAN, MAX
5,964 of 5,963matt c
Description:
For this challenge you need to create a simple SELECT statement. Your task is to calculate the MIN, MEDIAN and MAX scores of the students from the results table.
Tables and relationship below:
Resultant table:
- min
- median
- max
SQL
Statistics
Fundamentals
Similar Kata:
Stats:
| Created | Oct 30, 2016 |
| Published | Oct 30, 2016 |
| Warriors Trained | 10926 |
| Total Skips | 2175 |
| Total Code Submissions | 37200 |
| Total Times Completed | 5963 |
| SQL Completions | 5964 |
| Total Stars | 183 |
| % of votes with a positive feedback rating | 84% of 668 |
| Total "Very Satisfied" Votes | 498 |
| Total "Somewhat Satisfied" Votes | 131 |
| Total "Not Satisfied" Votes | 39 |
| Total Rank Assessments | 8 |
| Average Assessed Rank | 5 kyu |
| Highest Assessed Rank | 4 kyu |
| Lowest Assessed Rank | 7 kyu |
