Hi Ryan, Can you see why I made my username "ThanksRyan"? Your ability to, not only craft the CTE, but explain it with the detail you did is truly appreciative. This community, because of the kind of person drh and his team are, fosters humble, helpful, talented folks. Thank you for being a member here and patiently contributing to help people better understand SQL and SQLite.