To determine the total number of tickets with pending statuses at the end of each day, we are attempting to build a query. The backlog and ticket updates databases have been tried, but none provide the results we are looking for.