计算状态等于成功的所有金额，如何修改SQL查询以达到目的？
- and message.invokeMethod: batchDeductResult and NORMAL not message.bizInfo.status: PROCESSING | SELECT json_extract_scalar(message, '$.bizInfo.fundSource') AS fundSource,date_format(time, '%Y-%m-%d') as deductDate, cast(json_extract_scalar(message, '$.bizInfo.deductHour') AS bigint) AS deductHour, count_if(json_extract_scalar(message, '$.bizInfo.status')='SUCCESS') as successCount ,COUNT(*) as totalCount,sum FROM log GROUP BY deductDate,fundSource, deductHour limit 1000000 计算状态等于成功的所有金额，如何修改SQL查询以达到目的？
收起
提问的橘子
2024-08-05 15:48:24
45
发布于辽宁
分享
版权
举报
