Untitled

select date(recon_start_date) as Event_Date,event_type,sum(total_no_of_events) as No_of_events_published,sum(no_of_passed_events) as No_of_success_events,sum(no_of_failed_events) as No_of_failed_events,sum(no_of_passed_events_via_recon) as No_of_passed_events_through_recon from hos_event_recon_summary group by date(recon_start_date),event_type order by date(recon_start_date) desc;

can you modify above query such that i want to retrieve data from recon_start_date 7th august 2023 to 11th august 2023