Link
Tables
erDiagram
OCCUPATIONS {
Name String
Occupation String
}
Mermaid
복사
DataFlow
CONCAT 으로 문자열 표현
Answer
SELECT
CONCAT(Name, '(', LEFT(Occupation, 1), ')')
FROM OCCUPATIONS
ORDER BY Name ASC;
SELECT
CONCAT('There are a total of ', COUNT(Name), ' ', LOWER(Occupation), 's.')
FROM OCCUPATIONS
GROUP BY Occupation
ORDER BY COUNT(Name) ASC, Occupation ASC;
SQL
복사