hackerrank Top Earners

 

1)

salary * months = earnings

 

1-1)

SELECT *, salary * months AS earnings

FROM Employee

 

위를 포함한 106줄 출력

 

 

1-2) 

SELECT salary * months AS earnings

FROM Employee

GROUP BY earnings

 

 

 

1-3)

SELECT salary * months AS earnings

FROM Employee

GROUP BY earnings

ORDER BY earnings

 

ASC

 

 

1-4)

SELECT salary * months AS earnings

FROM Employee

GROUP BY earnings

ORDER BY earnings DESC

 

DESC

 

 

1-5)

SELECT salary * months AS earnings

FROM Employee

GROUP BY earnings

ORDER BY earnings DESC

LIMIT 1;

 

 

 

2) 갯수 출력 

COUNT(*)

 

2-1)

SELECT salary * months AS earnings, COUNT(*)

FROM Employee

GROUP BY earnings

ORDER BY earnings DESC

LIMIT 1;

 

 

 

SUCCESS!