You are viewing a single comment's thread. Return to all comments →
with raw AS ( select avg(Salary) as actual ,avg(cast(replace(Salary,'0','') as SIGNED)) as mis_calculated from EMPLOYEES )
select ceil(actual - mis_calculated) from raw
Seems like cookies are disabled on this browser, please enable them to open this website
The Blunder
You are viewing a single comment's thread. Return to all comments →
with raw AS ( select avg(Salary) as actual ,avg(cast(replace(Salary,'0','') as SIGNED)) as mis_calculated from EMPLOYEES )
select ceil(actual - mis_calculated) from raw