[HackerRank/SQL] Basic SELECT - Employee Salaries

Problem. Basic SELECT - Employee Salaries

---

Link.

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

Employee Salaries | HackerRank

---

Description.

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.

Sort your result by ascending employee_id.

 

Employee 테이블

Employee 테이블 예시

---

Key Point. 

SELECT,

 

WHERE,

---

My Answer. 

SELECT E.name
FROM Employee E
WHERE E.salary > 2000 AND E.months < 10;

---

References.