[HackerRank](E) Employee Salaries

 

https://www.hackerrank.com/challenges/salary-of-employees/problem?isFullScreen=true 

Employee Salaries | HackerRank

 

[문제]

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.

Input Format

The Employee table containing employee data for a company is described as follows:

where employee_id is an employee's ID number, name is their name, months is the total number of months they've been working for the company, and salary is the their monthly salary.

[답]

-mysql

select name from employee
where salary > 2000
and months < 10
order by employee_id;

salary가 2000달러 이상이고, 10개월보다 적은 근속을 가진 직원을 조회해서, id로 오름차순 정렬하면 되는 쿼리이다.