'Write a Query in MySql server that prints a list of employee names who have been employed for less than 10 months having salary>2000

I want a SQL query that prints a list of employee names who have been employed for less than 10 months having salary>2000. Sort this result by ascending emp_id.

I tried this but gave me an error stating extract is no longer used.:

select * from emp where 
salary>2000 and (months_between(date, hire_date))<=10
order by emp_no asc ;

How do I form the query?

mysqlsql


Solution 1:[1]

SELECT *
FROM Emp 
WHERE Salary > 2000
  AND Hire_Date >= DATE_SUB(CURRENT_DATE, INTERVAL 10 MONTH)
ORDER BY emp_no ASC;
Emp_No Employee_Name Job ManagerID Hire_Date Salary Comm DepartmentID
7566 JONES MANAGER 7839 2021-04-02 2975.00 null 20
7698 BLAKE MANAGER 7839 2021-05-01 2850.00 null 30
7782 CLARK MANAGER 7839 2021-06-09 2450.00 null 10
7788 SCOTT ANALYST 7566 2021-07-13 3000.00 null 20
7839 KING PRESIDENT null 2021-11-17 5000.00 null 10
7902 FORD ANALYST 7566 2021-12-03 3000.00 null 20

Demo on db<>fiddle here

Solution 2:[2]

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

Solution 3:[3]

I made this test on RackerRank on 04-25-2022:

The expected result only includes the name field, if you include any other fields you will get the message "wrong answer" as a result. All fields in order by clause may be in the list of fields, thus the only way I got it was:

select main.name from
    (select employee_id, name from employee where salary>2000 and months<10 order by employee_id asc) as main;

Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source
Solution 1
Solution 2 Ah Sa Fa
Solution 3 Sidon

Related Questions