select round(sum(pay_amount*(datediff(end_date,begin_date)+1)/days),2) from (select user_id,days,pay_amount, case when begin_date < '2021-09-01' then '2021-09-01' else begin_date end begin_date, case when end_date > '2021-09-30' then '2021-09-30' else end_date end end_date from detail_list_tb where month(begin_date) = 9 or month(end_date) = 9 or (month(begin_date) < 9 and month(end_date) > 9))s
点赞

相关推荐

牛客网
牛客网在线编程
牛客网题解
牛客企业服务