>Do you really want to update all 3 million records?
>
>This SQL is convoluted... what exactly are you trying to do?
It is a data fix. So, we have to do it over all the records.
So, each record will be updated by one of the value of the two WHERE WHEN CASE or 0.