The PADS MySQL

문제

https://www.hackerrank.com/challenges/the-pads/problem

The PADS | HackerRank

풀이

• 문자열 연결 함수 CONCAT을 사용한다.

SELECT CONCAT(NAME, '(', SUBSTR(OCCUPATION, 1, 1), ')') 
FROM OCCUPATIONS 
ORDER BY NAME, SUBSTR(OCCUPATION, 1, 1);
SELECT CONCAT('There are a total of ', COUNT(OCCUPATION), ' ', LOWER(OCCUPATION), 's.') 
FROM OCCUPATIONS 
GROUP BY OCCUPATION ORDER BY COUNT(OCCUPATION), OCCUPATION;​