8 kyu
SQL Basics: Simple WHERE and ORDER BY
27,451 of 27,452matt c
Description:
For this challenge you need to create a simple SELECT statement that will return all columns from the people table WHERE their age is over 50
people table schema
- id
- name
- age
You should return all people fields where their age is over 50 and order by the age descending
NOTE: Your solution should use pure SQL. Ruby is used within the test cases to do the actual testing.
SQL
Filtering
Databases
Fundamentals
Similar Kata:
Stats:
| Created | Oct 20, 2016 |
| Published | Oct 20, 2016 |
| Warriors Trained | 29916 |
| Total Skips | 1130 |
| Total Code Submissions | 49649 |
| Total Times Completed | 27452 |
| SQL Completions | 27451 |
| Total Stars | 70 |
| % of votes with a positive feedback rating | 89% of 2368 |
| Total "Very Satisfied" Votes | 1944 |
| Total "Somewhat Satisfied" Votes | 339 |
| Total "Not Satisfied" Votes | 85 |
| Total Rank Assessments | 9 |
| Average Assessed Rank | 7 kyu |
| Highest Assessed Rank | 7 kyu |
| Lowest Assessed Rank | 8 kyu |
