It’s hard to believe I wrote this in 2015. I’d have thought that it was a topic I would have covered earlier than that. Looking back, I think knowing how to use a tally or numbers table is a core SQL skill.

Still on vacation, but re-read The Tally Table and see what you think.