Return to JUNTO

JUNTO Practice: Hackerrank, "Employee Salaries"

Discussed on July 24, 2019.

Hackerrank, "Employee Salaries"

Solutions

Click to see:

Oscar Martinez

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

John Lekberg

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

Daniel Bassett

SELECT NAME FROM EMPLOYEE WHERE SALARY > 2000 AND MONTHS < 10 
;