This is the current query:
这是当前的查询:
SELECT status.ct_reconcile_status,
IFNULL(COUNT(status.ct_reconcile_status), 0) AS sch_change_status_num
FROM db_crewops_cm_action status
WHERE status.ct_reconcile_status IN ( 'SUCCESS', 'FAILED' )
AND status.updated_ts > UTC_TIMESTAMP() - INTERVAL 60 minute
GROUP BY status.ct_reconcile_status;
SELECT