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'