나는 이렇게 학습한다/Algorithm & SQL

Adults only (SQL for Beginners #1)

daco2020 2022. 6. 25. 00:02
반응형

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.

 

Solution:

SELECT 
  name,
  age
FROM
  users
WHERE
  age >= 18

 

 

반응형

'나는 이렇게 학습한다 > Algorithm & SQL' 카테고리의 다른 글

SQL Basics - Trimming the Field  (0) 2022.06.26
SQL: Disorder  (0) 2022.06.25
SQL: Padding Encryption  (0) 2022.06.23
Sum of angles  (0) 2022.06.22
SQL Basics: Up and Down  (0) 2022.06.21