6 kyu
SQL Basics: Simple HAVING
20,048 of 20,049matt c
Description:
For this challenge you need to create a simple HAVING statement, you want to count how many people have the same age and return the groups with 10 or more people who have that age.
people table schema
- id
- name
- age
return table schema
- age
- total_people
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 30, 2016 |
| Published | Oct 30, 2016 |
| Warriors Trained | 25991 |
| Total Skips | 1854 |
| Total Code Submissions | 46581 |
| Total Times Completed | 20049 |
| SQL Completions | 20048 |
| Total Stars | 119 |
| % of votes with a positive feedback rating | 92% of 1984 |
| Total "Very Satisfied" Votes | 1673 |
| Total "Somewhat Satisfied" Votes | 287 |
| Total "Not Satisfied" Votes | 24 |
| Total Rank Assessments | 10 |
| Average Assessed Rank | 6 kyu |
| Highest Assessed Rank | 6 kyu |
| Lowest Assessed Rank | 8 kyu |
