select count (ID) from tbProcessTracking where ProcessType = 'Precheckinemail' and CreatedDateTime between '2023-07-27 23:59:43.440' and '2023-08-02 23:59:43.440' and EmailSent='1'
select count (ID) from tbProcessTracking where ProcessType = 'Precheckoutemail' and CreatedDateTime between '2023-07-27 23:59:43.440' and '2023-08-02 23:59:43.440' and EmailSent='1'