Using Case Statement Alias in WHERE Clause: A Creative Solution

Clickhouse Cross Joins and Workarounds for Handling Aggregate Values