Query all employe names from Employee table having salary greater than $2000

Author: Al-mamun Sarkar Date: 2020-03-28 10:13:49

Query all employe names from Employee table having salary greater than $2000 and months less than 10 months and sort by employee_id in ascending order. This is the solution of HackerRank's Employee Salaries SQL problem.

Table name: Employee

SQL Query:

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