使用 SQL 的 CASE 语句做付款方式的统计

有一张资料表如下：

PayType 有四种付款方式，希望得到如下的统计结果：

SQL 语句如下：

SELECT OrderDate,
       SUM(CASE WHEN PayType = 1 THEN OrderCount ELSE 0 END) AS CX_1,
       SUM(CASE WHEN PayType = 2 THEN OrderCount ELSE 0 END) AS CX_2,
       SUM(CASE WHEN PayType = 3 THEN OrderCount ELSE 0 END) AS CX_3,
       SUM(CASE WHEN PayType = 4 THEN OrderCount ELSE 0 END) AS CX_4,
       SUM(CASE WHEN PayType = 1 THEN OrderAmount ELSE 0 END) AS AX_1,
       SUM(CASE WHEN PayType = 2 THEN OrderAmount ELSE 0 END) AS AX_2,
       SUM(CASE WHEN PayType = 3 THEN OrderAmount ELSE 0 END) AS AX_3,
       SUM(CASE WHEN PayType = 4 THEN OrderAmount ELSE 0 END) AS AX_4
  FROM `yearmonth_paytype` 
 WHERE OrderDate BETWEEN "2022-10-27" AND "2022-10-31"
   AND SettleNo = 15268
 GROUP BY OrderDate;