반응형
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 |