[해커랭크/SQL] 20. Employee Salaries

👉 https://www.hackerrank.com/challenges/salary-of-employees/problem?isFullScreen=true

Employee Salaries | HackerRank

 

---

 

🤔 문제 분석

1) Write a query that prints a list of employee names (i.e.: the name attribute) for employees in Employee having a salary greater than  per month who have been employees for less than  months.

2) Sort your result by ascending employee_id.

 

💡 풀이

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