[해커랭크] The PADS

[해커랭크] The PADS

 

https://www.hackerrank.com/challenges/the-pads/problem?isFullScreen=true 

The PADS | HackerRank

 

문제)

1. Query an alphabetically ordered list of all names in OCCUPATIONS, immediately followed by the first letter of each profession as a parenthetical (i.e.: enclosed in parentheses). For example: AnActorName(A), ADoctorName(D), AProfessorName(P), and ASingerName(S). 
   
   
2. Query the number of ocurrences of each occupation in OCCUPATIONS. Sort the occurrences in ascending order, and output them in the following format: 
   There is a total of [occupation_count], [occupation]s.
   where [occupation_count] is the number of occurrences of an occupation in OCCUPATIONS and [occupation] is the lowercase occupation name. If more than one Occupation has the same [occupation_count], they should be ordered alphabetically.

select concat(name, '(', substr(occupation, 1, 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);