Group by the specific day, month, and year

I have a table as follow, now I use the group by date and it only group my data based on the year. I want to group the data based on the specific day, month, and year.

Do you know how we can do that?

Answer

Use:

group by  day(`date`),month(`date`),year(`date`)

Check for more info