Back to questions

Patient Support Analysis (Part 1) UnitedHealth SQL Interview Question

Patient Support Analysis (Part 1)

UnitedHealth SQL Interview Question

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.

Write a query to find how many UHG policy holders made three, or more calls, assuming each call is identified by the column.

If you like this question, try out Patient Support Analysis (Part 2)!

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-6f099cc2cc5eclaims assistance2023-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:

policy_holder_count
1

Explanation:

The only caller who made three, or more calls is policy holder ID 2.

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

Input

(PostgreSQL)

Output