Agreed.
I was talking about records 3, 6, and 12 having dates within the test date range, 08/07/2021 - 29/07/2021. Yes, I did make a mistake and say record 16 instead of 12 in my original message.
Records 3, 6, and 12 are all Room_ID= 0006 and type= 01.