any_value(…) filter(…)        

1. ⚡Might return null even if there are non-null values
2. ⚡Not an aggregate function