该博客提供了在HackerRank上解决SQL高级查询问题的示例，涉及从OCCUPATIONS表中按字母顺序获取职业名称，并括注每个职业的首字母。此外，还展示了如何查询每个职业在表中的出现次数，结果按出现次数升序和职业名称字母顺序排列。给出了两种不同的SQL查询解答方法，一种使用concat和substring或left函数，另一种使用case when语句进行条件判断。
Generate the following two result sets:
- 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), andASingerName(S). -
Query the number of ocurrences of each occupation in OCCUPATIONS. Sort the occurrences in ascending order, and output them in the following format:
There are 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.
最低0.47元/天 解锁文章
扫一扫
693
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
