Cacher is the code snippet organizer for pro developers

SELECT count(later_appointment_id),date(appointment_dt) FROM `later_appointment` where appointment_dt BETWEEN '2018-10-25 00:00:00' AND '2018-10-31 23:59:59'
GROUP by date(appointment_dt)