It's worth noting here that the comment suggesting "--note the 'RECURSIVE' keyword, which states that we want to define a CTE" isn't exactly correct. This is a recursive CTE, but the RECURSIVE isn't required for it to still be a CTE...