题解 | #实习广场投递简历分析(一)#
实习广场投递简历分析(一)
http://www.nowcoder.com/practice/f5fc21a0630b4ca6a25ea3a48054ef47
1.分析
sum不是count
LIKE运算符用于WHERE表达式中,以搜索匹配字段中的指定内容
2.代码
SELECT job, sum(num) as cnt from resume_info WHERE date LIKE '2025%' GROUP BY job ORDER BY cnt DESC