The PADS(SQL)

"OCCUPATIONS"라는 테이블에서 두 가지 결과 집합을 생성해야 합니다.

첫 번째 결과 집합은 다음과 같습니다:

"알파벳 순으로 정렬된 모든 이름과 직업의 첫 글자를 괄호 안에 표시한 목록을 가져오세요."

예를 들어, "AnActorName(A), ADoctorName(D), AProfessorName(P), and ASingerName(S)"와 같은 결과를 생성해야 합니다.

두 번째 결과 집합은 다음과 같습니다:

"각 직업의 발생 횟수를 가져오세요. 발생 횟수를 오름차순으로 정렬하고 다음 형식으로 출력하세요:"

"There are a total of [occupation_count] [occupation]s."

여기서 [occupation_count]는 OCCUPATIONS 테이블에서 해당 직업이 등장한 횟수이고, [occupation]은 해당 직업 이름의 소문자 버전입니다. 만약 두 개 이상의 직업이 같은 [occupation_count]를 가지고 있다면, 알파벳 순으로 정렬되어야 합니다.

두 가지 결과 집합을 생성하는 SQL 쿼리를 작성해야 합니다. 첫 번째 결과 집합은 이름과 직업의 첫 글자를 결합하고 알파벳 순으로 정렬하면 됩니다. 두 번째 결과 집합은 각 직업의 발생 횟수를 계산하고 정렬한 후 주어진 형식에 맞게 출력해야 합니다.

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;