HR-SQL The PADS 문서 원본 보기

==개요==
;HR-SQL The PADS
*https://www.hackerrank.com/challenges/the-pads/problem

{{HR-SQL 헤더}}
{{HR-SQL Advanced Select}}
|}

==DB2==
<syntaxhighlight lang='sql'>
</syntaxhighlight>

==MS SQL==
<syntaxhighlight lang='sql'>
</syntaxhighlight>

==MySQL==
<syntaxhighlight lang='mysql'>
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), Occupation;
</syntaxhighlight>

==Oracle==
<syntaxhighlight lang='sql'>
</syntaxhighlight>