How to use GROUP BY MONTH(updated_at), DAY(updated_at) in MySQL?

[lz1998]

How to use SELECT MONTH(updated_at), DAY(updated_at), count(*) from table_a GROUP BY MONTH(updated_at), DAY(updated_at) in MySQL?

[lz1998]

How to execute this?

select
  DATE_FORMAT(updated_at, '%Y%m%d') AS date,
  count(*)
from
  table_a
group by
  date