Top Earners

Jimin·2022년 8월 25일
0

HackerRank

목록 보기
7/27

SELECT MAX(total), COUNT(*)
FROM 
(SELECT salary * months total FROM Employee) t,
(SELECT MAX(salary * months) M FROM Employee)
WHERE M = total;
SELECT MAX(t.total), COUNT(*)
FROM (SELECT salary * months total FROM Employee) t
WHERE t.total = (SELECT MAX(salary * months) M FROM Employee);
profile
https://github.com/Dingadung

0개의 댓글