logo

Back to questions

Patient Support Analysis (Part 2) [UnitedHealth SQL Interview Question]

Easy

UnitedHealth Group 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.

Table:

Column NameType
policy_holder_idinteger
case_idvarchar
call_categoryvarchar
call_receivedtimestamp
call_duration_secsinteger
original_orderinteger

Example Input:

policy_holder_idcase_idcall_categorycall_receivedcall_duration_secsoriginal_order
52481621a94c-2213-4ba5-812d01/17/2022 19:37:00286161
51435044f0b5-0eb0-4c49-b21en/a01/18/2022 2:46:00208225
52082925289b-d7e8-4527-bdf5benefits01/18/2022 3:01:00291352
5462461262c2-d9a3-44d2-9065IT_support01/19/2022 0:27:00273358
546246129f57-164b-4a36-934eclaims01/19/2022 6:33:00157362

Example Output:

call_percentage
40.0

Explanation:

A total of 5 calls were registered. Out of which 2 calls were not categorised. That makes 40.0% (2/5 x 100.0) of the calls uncategorised.

The dataset you are querying against may have different input & output - this is just an example!

PostgreSQL 14