We use cookies to ensure you have the best browsing experience on our website. Please read our cookie policy for more information about how we use cookies.
Why this doesnt work:
SELECT
CEILING(
AVG(Salary) -
AVG(CASE
WHEN REPLACE(CAST(Salary AS VARCHAR), '0', '') = ''
THEN 0
ELSE CAST(REPLACE(CAST(Salary AS VARCHAR), '0', '') as bigint)
END)
) AS ErrorAmount
FROM
EMPLOYEES
Cookie support is required to access HackerRank
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 →
Why this doesnt work: SELECT CEILING( AVG(Salary) - AVG(CASE WHEN REPLACE(CAST(Salary AS VARCHAR), '0', '') = '' THEN 0 ELSE CAST(REPLACE(CAST(Salary AS VARCHAR), '0', '') as bigint) END) ) AS ErrorAmount FROM EMPLOYEES