8 kyu
SQL Basics: Simple WHERE and ORDER BY
26,815 of 26,816matt 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 | 29225 |
Total Skips | 1101 |
Total Code Submissions | 48624 |
Total Times Completed | 26816 |
SQL Completions | 26815 |
Total Stars | 70 |
% of votes with a positive feedback rating | 89% of 2343 |
Total "Very Satisfied" Votes | 1921 |
Total "Somewhat Satisfied" Votes | 338 |
Total "Not Satisfied" Votes | 84 |
Total Rank Assessments | 9 |
Average Assessed Rank | 7 kyu |
Highest Assessed Rank | 7 kyu |
Lowest Assessed Rank | 8 kyu |