www.hackerrank.com/challenges/name-of-employees/problem
Employee Names | HackerRank
Print employee names.
www.hackerrank.com
Answer
select name
from employee
order by namewww.hackerrank.com/challenges/salary-of-employees/problem
Employee Salaries | HackerRank
Print the names of employees who earn more than $2000 per month and have worked at the company for less than 10 months.
www.hackerrank.com
select name
from employee
where months < 10 and salary > 2000
order by employee_id728x90
반응형
'SQL & DB > HackerRank SQL Problem' 카테고리의 다른 글
| [HackerRank SQL] The PADS (MySQL) (0) | 2021.02.27 |
|---|---|
| [HackerRank SQL] Type of Triangle (0) | 2021.02.27 |
| [HackerRank SQL] Higher Than 75 Marks (0) | 2021.02.27 |
| [HackerRank SQL] Weather Observation Station 11, 12(MySQL) (0) | 2021.02.27 |
| [HackerRank SQL] Weather Observation Station 9, 10(MySQL) (0) | 2021.02.27 |