logo

Back to questions

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

Easy

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

Write a query to find how many UHG members made 3 or more calls. column uniquely identifies each call made.

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

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
50837000dc63-acae-4f39-bb04claims03/09/2022 02:51:00205130
5083700041be-bebe-4bd0-a1baIT_support03/12/2022 05:37:00254129
5093667412c8-b35c-48a3-b38dclaims05/31/2022 7:27:0024031
50886837d0b4-8ea7-4b8c-aa8bIT_support03/11/2022 3:38:0027616
50886837a741-c279-41c0-90ba03/19/2022 10:52:00131325
50837000bab1-3ec5-4867-90aebenefits05/13/2022 18:19:00228339

Example Output:

member_count
1

Explanation:

The only caller who made 3 or more calls is member ID 50837000.

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

PostgreSQL 14