๐ฏ- Day 22 of SQL Series
๐งต๐
๐งต๐
โProblem Statement : @UnitedHealthGrp has a program called Advocate4Me, which allows members to call an advocate and receive support for their #health care needs โ whether that's behavioural, clinical, well-being, health care financing, benefits, claims or #pharmacy help.
- Calls to the Advocate4Me call centre are categorised, but sometimes they can't fit neatly into a category. These uncategorised calls are labelled โn/aโ, or are just empty (when a support agent enters nothing into the category field).
Write a #query to find the percentage of calls that cannot be categorised. Round your answer to 1 decimal place.
๐ง Hints to Solve this Question
๐ Filter for uncategorised calls and count them.
๐ Count the total calls.
๐ Use the percentage formula.
๐ Round the output.
๐ Filter for uncategorised calls and count them.
๐ Count the total calls.
๐ Use the percentage formula.
๐ Round the output.
๐ ๐๐ข๐ ๐๐ก๐จ๐ฎ๐ญ๐จ๐ฎ๐ญ ๐ญ๐จ Shri @NickSinghTech Sir for providing such a great Content
โถ๏ธCode Snippet :
โถ๏ธCode Snippet :
โ Give it a try to this amazing Question & Don't Forget to Check the Previous Problem on my Profile
@Sachintukumar
๐๐๐ญ'๐ฌ ๐๐จ ๐ข๐ญ ๐ญ๐จ๐ ๐๐ญ๐ก๐๐ซ ๐
#60daysofcodechallenge #60daysofSQL #30daysofSQL #sqlqueries #100daysofcodechallenge #SQLquery
datalemur.com/questions/uncaโฆ
@Sachintukumar
๐๐๐ญ'๐ฌ ๐๐จ ๐ข๐ญ ๐ญ๐จ๐ ๐๐ญ๐ก๐๐ซ ๐
#60daysofcodechallenge #60daysofSQL #30daysofSQL #sqlqueries #100daysofcodechallenge #SQLquery
datalemur.com/questions/uncaโฆ
โข โข โข
Missing some Tweet in this thread? You can try to
force a refresh
ใ
