-
[HackerRank/Basic Select] Employee Salaries공부/PS ( SQL) 2022. 5. 16. 00:44
https://www.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 salary > 2000 AND months < 10 ORDER BY employee_id
'공부 > PS ( SQL)' 카테고리의 다른 글
[HackerRank/Advanced Select] The PADS (0) 2022.05.16 [HackerRank/Advanced Select] Type of Triangle (0) 2022.05.16 [HackerRank/Basic Select] Employee Names (0) 2022.05.16 [HackerRank/Basic Select] Higher Than 75 Marks (0) 2022.05.16 [HackerRank/Basic Select] Weather Observation Station 12 (0) 2022.05.16