You are viewing a single comment's thread. Return to all comments →
I am adding easier solution select ceil(avg(salary) - avg((to_number(replace(to_char(salary),'0',''))))) from employees;
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 →
I am adding easier solution select ceil(avg(salary) - avg((to_number(replace(to_char(salary),'0',''))))) from employees;