This is a conceptual example and not directly executable SQL. The logic outlines an approach to concatenate hashes vertically by block and search for patterns. -- CTE to aggregate hashes vertically by ...