[SQL] Employee Salaries

문제

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.

• Input Format
  The Employee table containing employee data for a company is described as follows:
  
  where employee_id is an employee's ID number, name is their name, months is the total number of months they've been working for the company, and salary is the their monthly salary.

• Sample Input
  

• Sample Output
  

정답

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