over 分组

SELECT DISTINCT
    a.bookDate as 日期,
    SUM(case a.paytype when 1 then 1 ELSE 0 end) over(partition by a.bookDate) '订场数（现金）',
    SUM(case a.paytype when 1 then b.price else 0 end) over(partition by a.bookDate) '资金额（现金）',
    SUM(case a.paytype when 2 then 1 ELSE 0 end) over(partition by a.bookDate) '订场数（积分）',
    SUM(case a.paytype when 2 then b.price else 0 end) over(partition by a.bookDate) '资金额（积分）'
FROM FA_Court.dbo.BookCourt a
inner join FA_Court.dbo.BookCourtDetail b on b.bookOrderId = a.id
where a.bookDate > '2020-09-15' and a.status = 2