MySQL Date and Time Functions

Select count by day:

select count(*), DAY(date_time) FROM table n group by DAY(date_time) order by date_time desc;