creation of this query

Creation of a query whenever the create a calendar and if end date match with the calendar date it subtract the number of item however if that item is 14 days old it will add

for example

date-----------lost----(Items)-Added-(Items) (Start Date) (End Date)------ Total
10/30/2024---2------A, B---- 3-------C,D, E --10/15/2024--10/30/2024 ---- 5
10/29/2024---0---------------2 -------G,H--- 10/14/2024 ------------------4

No files, tests, or entry points are named. First clarify the calendar schema and query environment, then define the exact end-date, lost-item, and 14-day rules using the provided examples as acceptance cases; the work is done when those examples produce the stated totals.

Written by the indexing model from the issue text.