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 2000 per month who have been employees for less than months. Sort your result by ascending employee_id.

 

SELECT name
FROM Employee
WHERE months < 10 and salary > 2000
ORDER BY employee_id asc;

Rose Patrick Lisa Amy Pamela Jennifer Julia Kevin Paul Donna Michelle Christina Brandon Joseph Jesse Paula Louise Evelyn Emily Jonathan Nancy Benjamin Roy Diana Christine