7 kyu
SQL Basics: Simple GROUP BY
22,849 of 22,854matt c
Description:
For this challenge you need to create a simple GROUP BY statement, you want to group all the people by their age and count the people who have the same age.
people table schema
- id
- name
- age
select table schema
- age [group by]
- people_count (people count)
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 | 29164 |
| Total Skips | 1407 |
| Total Code Submissions | 50655 |
| Total Times Completed | 22854 |
| SQL Completions | 22849 |
| Total Stars | 75 |
| % of votes with a positive feedback rating | 88% of 2208 |
| Total "Very Satisfied" Votes | 1749 |
| Total "Somewhat Satisfied" Votes | 389 |
| Total "Not Satisfied" Votes | 70 |
| Total Rank Assessments | 11 |
| Average Assessed Rank | 7 kyu |
| Highest Assessed Rank | 7 kyu |
| Lowest Assessed Rank | 8 kyu |
