The PADS (CONCAT, SUBSTR)

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

The PADS | HackerRank

해결 방법 : CONCAT, SUBSTR 함수

• CONCAT(str1, str2, ...) : 문자열 합치기
• SUBSTR(문자열, 첫 인덱스, 문자 개수) : 문자열 자르기

SELECT concat(name, '(', substr(occupation, 1, 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), occupation;