HackerRank MySQL - 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 10 months. Sort your result by ascending employee_id.
- /*
- Enter your query here and follow these instructions:
- 1. Please append a semicolon ";" at the end of the query and enter your query in a single line to avoid error.
- 2. The AS keyword causes errors, so follow this convention: "Select t.Field From table1 t" instead of "select t.Field From table1 AS t"
- 3. Type your code immediately after comment. Don't leave any blank line.
- */
-
- SELECT NAME
- FROM EMPLOYEE
- WHERE SALARY > 2000
- AND MONTHS < 10
- ORDER BY EMPLOYEE_ID;