Employee Salaries Solution

Hello Friends in this article i am gone to share Hacker Rank SQL Solutions with you | Employee Salaries Solution

Also Visit:ย  Employee Names Solution

Problem

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.

Sample Input

Sample Output

```Angela
Michael
Todd
Joe```

Explanation

Angela has been an employee for 1 month and earns \$3443 per month.
Michael has been an employee for 6 months and earns \$2017 per month.
Todd has been an employee for 5 months and earns \$3396 per month.
Joe has been an employee for 9 months and earns \$3573 per month.
We order our output by ascending employee_id.

Solution โ Employee Salaries Solution

MySQL Code
```select name from employee
where salary > 2000 and
months < 10 order By employee_id;```

Disclaimer: The above Problems are generated by Hacker Rank but the Solutions are Provided by NYANDER.COM. All Hacker Rank SQL Solutions Shared only for Educational and Learning Purpose.