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

Stats:

CreatedOct 20, 2016
PublishedOct 20, 2016
Warriors Trained29225
Total Skips1101
Total Code Submissions48624
Total Times Completed26816
SQL Completions26815
Total Stars70
% of votes with a positive feedback rating89% of 2343
Total "Very Satisfied" Votes1921
Total "Somewhat Satisfied" Votes338
Total "Not Satisfied" Votes84
Total Rank Assessments9
Average Assessed Rank
7 kyu
Highest Assessed Rank
7 kyu
Lowest Assessed Rank
8 kyu
Ad
Contributors
  • matt c Avatar
  • jhoffner Avatar
  • Chrono79 Avatar
  • kazk Avatar
Ad