为提高效率，提问时请提供以下信息，问题描述清晰可优先响应。
【DM版本】:DM8
【操作系统】：WIN10
【CPU】:锐龙R7
【问题描述】*：SELECT
(COUNT(l.id) - s.succeed)as failure,
s.succeed as success
FROM
t_log as l
LEFT JOIN
(
SELECT
id,
COUNT(id) as succeed
FROM
t_log
WHERE
type = 1
and DATE_FORMAT(set_time, ‘YYYY’)= ‘2021’

    ) as s

on
s.id = l.id
where
1=1
AND DATE_FORMAT(set_time, ‘YYYY’)= ‘2021’

两处日期后面加上Group By就不报错了,但是原本的查询结果会改变,求助!