[hackerrank] Employee Salaries

[hackerrank] Prepare > SQL > Basic Select >  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  per month who have been employees for less than  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  month and earns  per month.

Michael has been an employee for  months and earns  per month.

Todd has been an employee for  months and earns  per month.

Joe has been an employee for  months and earns  per month.

We order our output by ascending employee_id.

 

 

Oracle

 

 

 

10

 

/*

11

Enter your query here.

12

Please append a semicolon ";" at the end of the query and enter your query in a single line to avoid error.

13

*/

14

​

15

select name

16

from Employee

17

where salary > 2000

18

and months < 10

19

order by employee_id asc;

 

Line: 15 Col: 1

Run Code Submit Code

Upload Code as File

Sql

You have earned 10.00 points!

You are now 55 points away from the 3rd star for your sql badge.

 

56%245/300

Congratulations

You solved this challenge. Would you like to challenge your friends?

Share on FacebookShare on TwitterShare on LinkedIn

Next Challenge

Test case 0

Compiler Message

Success

Input (stdin)

Download

• INPUT

Expected Output

Download

• Rose 

• Patrick 

• Lisa 

• Amy 

• Pamela 

• Jennifer 

• Julia 

• Kevin 

• Paul 

• Donna 

• Michelle 

• Christina 

• Brandon 

• Joseph 

• Jesse 

• Paula 

• Louise 

• Evelyn 

• Emily 

• Jonathan {-truncated-}

• Download to view the full testcase

• Blog
• Scoring
• Environment

 

[MYSQL]

 

 

[ORCALE]

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