题解 | #实习广场投递简历分析(二)#

条件运算符

> 、< 、<= 、>= 、= 、<>
BETWEEN...AND  
IN( 集合) 
LIKE：模糊查询
    占位符：
         _:单个任意字符
        %：多个任意字符
IS NULL  
and  或 &&
or  或 || 
not  或 !

SELECT job,DATE_FORMAT(date,"%Y-%m") as mon,sum(num) as cnt
from resume_info
where date like '2025%'
GROUP BY job,mon
order by mon desc,cnt desc