8 kyu
Adults only (SQL for Beginners #1)
34,716 of 34,724MaikelNabil
Description:
In your application, there is a section for adults only. You need to get a list of names and ages of users from the users table, who are 18 years old or older.
users table schema
- name
- age
NOTE: Your solution should use pure SQL. Ruby is used within the test cases just to validate your answer.
SQL for Beginners Series
This kata is part of a collection of SQL challenges for beginners. You can take the rest of the challenges here:
Fundamentals
SQL
Databases
Data Science
Similar Kata:
Stats:
Created | May 4, 2017 |
Published | May 4, 2017 |
Warriors Trained | 38894 |
Total Skips | 1324 |
Total Code Submissions | 54731 |
Total Times Completed | 34724 |
SQL Completions | 34716 |
Total Stars | 183 |
% of votes with a positive feedback rating | 93% of 3417 |
Total "Very Satisfied" Votes | 2974 |
Total "Somewhat Satisfied" Votes | 392 |
Total "Not Satisfied" Votes | 51 |
Total Rank Assessments | 167 |
Average Assessed Rank | 7 kyu |
Highest Assessed Rank | 1 kyu |
Lowest Assessed Rank | 8 kyu |