代码如下：

SELECT bizdate,paymethod,storecode,store,sum(amount) as amount
FROM
(
SELECT
ntp.name AS “platform”,
nss.name AS “store”,
nss.finance_code AS “storecode”,
npm.name AS “paymethod”,
np.amount AS “amount”,
nss.brand,
nss.accounting_org,
nso.business_hours AS “bizdate”
FROM
nt_payment np
JOIN
nt_sale_order nso ON nso.id=np.order_id
JOIN
nt_sale_shop nss ON nss.id=nso.shop_id
JOIN
nt_payment_method npm ON npm.id=np.method_ids
LEFT JOIN
nt_third_platform ntp ON ntp.id=npm.platform_id
WHERE
ntp.name is NULL
and nso.business_hours BETWEEN ‘2021-07-30’ AND ‘2021-07-31’
) t
GROUP BY bizdate,paymethod,storecode,store