Hackerrank / The PADS

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

The PADS | HackerRank

 

# MySQL

select CONCAT(NAME,'(', SUBSTR(Occupation,1,1),')')
from OCCUPATIONS 
order by Name;

select CONCAT('There are a total of ', A.oc_cnt, ' ', lower(A.Occupation),'s.')
from (select Occupation, count(Occupation) as oc_cnt from OCCUPATIONS 
      group by Occupation order by oc_cnt, Occupation) A;

 

MySQL은 문장을 생성할 때 (+) 기호 사용이 불가능하다.