How to simplify a sql with a lot of “case when then else …” – Mysql
Run into sql code with a lot of when: case when callDuration > 0 and callDuration < 30 then 1.4 when callDuration >= 30 and callDuration < 60 then 2.3 when callDuration >= 60 and callDuration < 120 then 3.7…