Database/SQL
2021. 11. 30.
Hackerrank / The PADS
https://www.hackerrank.com/challenges/the-pads/problem?isFullScreen=true The PADS | HackerRank Query the name and abbreviated occupation for each person in OCCUPATIONS. www.hackerrank.com # 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(Occupat..