79685962

Date: 2025-07-01 11:14:27
Score: 2.5
Natty:
Report link

Use a CTE to evaluate the case, then the main query can filter -

with x as (select ... case this, case that ... from tbls)
select <whatever> from x where <your-filters>;

Reasons:
  • Low length (1):
  • No code block (0.5):
  • Low reputation (1):
Posted by: Kenny Pellerin