6 kyu
SQL Basics: Simple HAVING
19,818 of 19,819matt 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 | 25691 |
| Total Skips | 1840 |
| Total Code Submissions | 46184 |
| Total Times Completed | 19819 |
| SQL Completions | 19818 |
| Total Stars | 117 |
| % of votes with a positive feedback rating | 92% of 1971 |
| Total "Very Satisfied" Votes | 1664 |
| Total "Somewhat Satisfied" Votes | 283 |
| Total "Not Satisfied" Votes | 24 |
| Total Rank Assessments | 10 |
| Average Assessed Rank | 6 kyu |
| Highest Assessed Rank | 6 kyu |
| Lowest Assessed Rank | 8 kyu |
