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:

  1. Adults only (SQL for Beginners #1)
  2. On the Canadian Border (SQL for Beginners #2)
  3. Register for the Party (SQL for Beginners #3)
  4. Collect Tuition (SQL for Beginners #4)
  5. Best-Selling Books (SQL for Beginners #5)
  6. Countries Capitals for Trivia Night (SQL for Beginners #6)
Fundamentals
SQL
Databases
Data Science

Stats:

CreatedMay 4, 2017
PublishedMay 4, 2017
Warriors Trained38894
Total Skips1324
Total Code Submissions54731
Total Times Completed34724
SQL Completions34716
Total Stars183
% of votes with a positive feedback rating93% of 3417
Total "Very Satisfied" Votes2974
Total "Somewhat Satisfied" Votes392
Total "Not Satisfied" Votes51
Total Rank Assessments167
Average Assessed Rank
7 kyu
Highest Assessed Rank
1 kyu
Lowest Assessed Rank
8 kyu
Ad
Contributors
  • MaikelNabil Avatar
  • ZED.CWT Avatar
Ad