In my endless search for the end of the internet, I stumbled across a fun SQL Puzzle.  Link: https://www.itprotoday.com/sql-server/t-sql-puzzle-challenge-grouping-connected-items