logo

Back to questions

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

Easy

UnitedHealth Group (UHG) has a program called Advocate4Me, which allows policy holders (or, members) to call an advocate and receive support for their health care needs – whether that's claims and benefits support, drug coverage, pre- and post-authorisation, medical records, emergency assistance, or member portal services.

Calls to the Advocate4Me call centre are classified into various categories, but some calls cannot be neatly categorised. These uncategorised calls are labeled as “n/a”, or are left empty when the support agent does not enter anything into the call category field.

Write a query to calculate the percentage of calls that cannot be categorised. Round your answer to 1 decimal place. For example, 45.0, 48.5, 57.7.

Table:

Column NameType
policy_holder_idinteger
case_idvarchar
call_categoryvarchar
call_datetimestamp
call_duration_secsinteger

Example Input:

policy_holder_idcase_idcall_categorycall_datecall_duration_secs
1f1d012f9-9d02-4966-a968-bf6c5bc9a9feemergency assistance2023-04-13T19:16:53Z144
141ce8fb6-1ddd-4f50-ac31-07bfcce6aaabauthorisation2023-05-25T09:09:30Z815
29b1af84b-eedb-4c21-9730-6f099cc2cc5en/a2023-01-26T01:21:27Z992
28471a3d4-6fc7-4bb2-9fc7-4583e3638a9eemergency assistance2023-03-09T10:58:54Z128
238208fae-bad0-49bf-99aa-7842ba2e37bcbenefits2023-06-05T07:35:43Z619

Example Output:

uncategorised_call_pct
20.0

Explanation:

Out of the total of 5 calls registered, one call was not categorised. Therefore, the percentage of uncategorised calls is calculated as 20.0% (1 out of 5 multiplied by 100 and rounded to one decimal place).

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

PostgreSQL 14