[HackerRank] The PADS

 

 

[문제]

이미지를 누르면 문제 링크로 넘어갑니다

 

 

[MySQL]

SELECT CONCAT(Name, '(', LEFT(Occupation, 1), ')') AS Output
FROM OCCUPATIONS
ORDER BY Output;

SELECT CONCAT('There are a total of ', COUNT(*), ' ', LOWER(Occupation), 's.') AS Output
FROM OCCUPATIONS
GROUP BY Occupation
ORDER BY COUNT(*) ASC, Occupation ASC