SQL (Snowflake) forward looking event date attribution I have the following table with these constraints –