Today I learned to never, ever assume that any scheduled queries written & deployed by someone else won’t be contradicted by that same person in another scheduled query.
If you find a scheduled query (don’t use them, just don’t…) that populates a table but produces a result different than what you expect (read: has significantly fewer or more rows), examine every single scheduled query that runs after the first one. You may find there is a second scheduled query that overwrites the first one. No, really.