mysql 中 GROUP BY 与DATE_FORMAT一起使用的时候 多个分组条件时只分组一个

mysql 中 GROUP BY 与DATE_FORMAT一起使用的时候 多个分组条件时只分组一个

SELECT
    DATE_FORMAT(
        concat(
            date(sd.modify_date),
            ' ',
            FLOOR(HOUR(sd.modify_date) / 2) * 2
        ),
        '%H:%00:00'
    ) AS modify_date,
    ANY_VALUE (sd.s_data) AS s_data,
    ANY_VALUE (sd.device_id) AS device_id,
    ANY_VALUE (sd. NAME) AS NAME,
    ANY_VALUE (sd.s_id) AS s_id,
    ANY_VALUE (sd.id) AS id
FROM
    sensing_data AS sd
LEFT JOIN sensing AS s ON s.id = sd.s_id
WHERE
    sd.modify_date BETWEEN '2023-03-24 00:00:00'
AND '2023-03-24 23:59:59'
AND sd.device_id = 10
AND s.is_delete = 0
AND s.data_type = 1
GROUP BY
    modify_date,
    s_id;

s_id本身是个聚合函数，分组什么呀
只有modify_date字段是不同的，其它字段只有一个值