[SQL] The PADS

https://www.hackerrank.com/challenges/the-pads/problem?isFullScreen=true

1) 코드

SELECT CONCAT(NAME, '(', LEFT(OCCUPATION, 1), ')') FROM OCCUPATIONS ORDER BY NAME;

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

2) 해설

• MySQL에서 문자열을 합칠 때, CONCAT 함수를 써주면 된다
• LOWER를 통해서 문자열을 소문자로 만들어줄 수 있다.