kshotx
Result

(SELECT DATE(registTime) as datetime, line_id, state, result, count(*) as cnt FROM kshotx.smsresult_20220216 group by datetime, line_id, state, result)