Prepare > SQL > Basic Select > Employee Salaries

Employee Salaries | HackerRank

 

문제

---

Write a query that prints a list of employee names (i.e.: the name attribute) for employees in Employee having a salary greater than $2000 per month who have been employees for less than 10 months. Sort your result by ascending employee_id.

 

 

 

 

코드

---

SELECT NAME FROM EMPLOYEE
WHERE salary > 2000 AND months < 10;

 

 

두 번째 시도

SELECT NAME FROM EMPLOYEE
WHERE SALARY > 2000 AND MONTHS < 10
ORDER BY EMPLOYEE_ID;