Operand should contain 1 column(s) 问题原因

在执行MySQL时，提示 1241 - Operand should contain 1 column(s)
问题原因及解决方法

select count(1) as num,
       DATE_FORMAT(create_time, '%Y-%m-%d') as ddd
       from tb_clue
where DATE_FORMAT(create_time, '%Y-%m-%d') BETWEEN '2021-01-01'
          AND '2022-12-30'
group by  (create_time,'yyyy-MM-dd')

//错误原因  group by  (create_time,'yyyy-MM-dd')  格式
//应该与上方时间格式保持一致 

正确格式如下

select count(1) as num,
       DATE_FORMAT(create_time, '%Y-%m-%d') as ddd
       from tb_clue
where DATE_FORMAT(create_time, '%Y-%m-%d') BETWEEN '2021-01-01'
          AND '2022-12-30'
group by  DATE_FORMAT(create_time, '%Y-%m-%d')

本文仅介绍了自己的错误原因及解决办法，各位如果有同样问题可以私信我汇总