[해커랭크] Employee Salaries

https://www.hackerrank.com/challenges/salary-of-employees/problem?isFullScreen=true&h_r=next-challenge&h_v=zen 

Employee Salaries | HackerRank

 

months가 10개월 미만이고, salary가 2000 초과인 것을 모두 충족해야 하므로 where절에 and

select name
from employee
where months < 10 and salary > 2000
order by employee_id asc