728x90
the PADS
-
The PADS<HackerRank> 2023. 7. 10. 21:45
The PADS -- DB2 SELECT (name || '(' || SUBSTR(occupation,1,1) || ')') FROM occupations ORDER BY name; SELECT ('There are a total of ' || COUNT(occupation) || ' ' || LOWER(occupation) || 's' || '.') FROM occupations GROUP BY occupation ORDER BY COUNT(occupation), occupation ASC; -- MYSQL SELECT CONCAT(Name, '(', (SUBSTRING(Occupation, 1, 1)), ')') FROM OCCUPATIONS ORDER BY Name ASC; SELECT CONCAT..