[해커랭크 SQL] Basic Select - Employee Salaries

❓ Question

https://www.hackerrank.com/challenges/salary-of-employees

Employee Salaries | HackerRank

 

 

❗ Answer

SELECT name
    FROM employee
    WHERE salary > 2000 AND months < 10
    ORDER BY employee_id;

📌 Discussion

- WHERE 에서 salary와 months에서 두가지 조건을 걸어줌