코딩코딩코딩

[HackerRank] Top Earners 본문

MySQL/Problem Solving

[HackerRank] Top Earners

hanshow113 2022. 1. 12. 01:52

 

 

 

SELECT salary*months AS earnings
     , count(*)
FROM Employee
GROUP BY earnings
ORDER BY earnings DESC
LIMIT 1;

'MySQL > Problem Solving' 카테고리의 다른 글

[LeetCode] 1179.Reformat Department Table, MySQL 피봇테이블  (0) 2022.02.06
[HackerRank] Type of Triangle  (0) 2022.01.18
[HackerRank] Weather Observation Station 15  (0) 2022.01.11
[HackerRank] Higher Than 75 Marks  (0) 2022.01.10
[HackerRank] Employee Salaries  (0) 2022.01.10
'MySQL/Problem Solving' Related Articles more
Comments