SQL84-实习广场投递简历分析(一)datediff()

牛客的课程订单分析(一)

http://www.nowcoder.com/practice/d3aa5df807f046bea5003dbc04965d67

select job, sum(num) as cnt
from resume_info
where left(date, 4) = 2025
group by job
order by sum(num) desc;

或者时间限制写法改成:
datediff(date,"2025-10-15")>0

全部评论

相关推荐

点赞 收藏 评论
分享
牛客网
牛客企业服务