Interview Guides

Top Friend Acceptance Rate | Dataford Interview Questions - Dataford - Ace your Interview

Top Friend Acceptance Rate

Easy

SQL & Data Manipulation

Asked at 1 company1JoinsAggregationsCase When

Also asked at

Problem

Task

At Meta, growth analysts often inspect invite and connection quality as part of the AARRR activation funnel for surfaces like Facebook Groups. You are given a table of friend request events and need to identify which sender has the highest acceptance rate.

Write a SQL query to find the user with the highest acceptance rate, defined as:

accepted requests sent / total non-null-status requests sent

Requirements

Compute acceptance rate at the sender_id level.
Count only rows where status is not NULL in the denominator.
Treat status = 'accepted' as an accepted request.
Return the sender with the highest acceptance rate.
Include these output columns: sender_id, accepted_requests, total_requests, acceptance_rate.
Order by acceptance_rate descending, then sender_id ascending, and return the top row only.

Table Definition

friend_requests

column	type	description
request_id	INT	Unique request identifier
sender_id	INT	User who sent the friend request
receiver_id	INT	User who received the friend request
status	VARCHAR(20)	Request outcome such as accepted, declined, pending, or NULL

Sample Data

request_id	sender_id	receiver_id	status
1	103	201	accepted
2	101	202	declined
3	104	203	pending
4	101	204	accepted
5	102	205	accepted
6	103	206	accepted

Expected Output

sender_id	accepted_requests	total_requests	acceptance_rate
103	2	2	1.0000

Schema

friend_requests

Column	Type	Description
request_idPK	INT	Unique identifier for each friend request
sender_id	INT	Meta user who sent the request
receiver_id	INT	Meta user who received the request
status	VARCHAR(20)	Request status such as accepted, declined, pending, or NULL

friend_requests

request_id	sender_id	receiver_id	status
1	103	201	accepted
2	101	202	declined
3	104	203	pending
4	101	204	accepted
5	102	205	accepted
6	103	206	accepted
7	102	207	declined
8	105	208
9	101	209	pending
10	104		accepted
11	106	210
12	102	211	pending
1	93	10	null
2	11	70	manual_review
3	95	25	failed
4	21	32	canceled
5	48	75	withdrawn
6	44	null	declined
7	74	85	processing
8	47	55	resubmitted
9	59	59	reopened
10	50	40	manual_review
11	84	41	declined
12	96	98	canceled
13	31	null	review_hold
14	72	81	failed
15	16	88	auto_declined
16	42	44	ignored

Expected Output

sender_id	accepted_requests	total_requests	acceptance_rate
103	2	2	1.0000

Problem

Task

Write a SQL query to find the user with the highest acceptance rate, defined as:

accepted requests sent / total non-null-status requests sent

Requirements

Compute acceptance rate at the sender_id level.
Count only rows where status is not NULL in the denominator.
Treat status = 'accepted' as an accepted request.
Return the sender with the highest acceptance rate.
Include these output columns: sender_id, accepted_requests, total_requests, acceptance_rate.
Order by acceptance_rate descending, then sender_id ascending, and return the top row only.

Table Definition

friend_requests

column	type	description
request_id	INT	Unique request identifier
sender_id	INT	User who sent the friend request
receiver_id	INT	User who received the friend request
status	VARCHAR(20)	Request outcome such as accepted, declined, pending, or NULL

Sample Data

request_id	sender_id	receiver_id	status
1	103	201	accepted
2	101	202	declined
3	104	203	pending
4	101	204	accepted
5	102	205	accepted
6	103	206	accepted

Expected Output

sender_id	accepted_requests	total_requests	acceptance_rate
103	2	2	1.0000

Schema

friend_requests

Column	Type	Description
request_idPK	INT	Unique identifier for each friend request
sender_id	INT	Meta user who sent the request
receiver_id	INT	Meta user who received the request
status	VARCHAR(20)	Request status such as accepted, declined, pending, or NULL

friend_requests

request_id	sender_id	receiver_id	status
1	103	201	accepted
2	101	202	declined
3	104	203	pending
4	101	204	accepted
5	102	205	accepted
6	103	206	accepted
7	102	207	declined
8	105	208
9	101	209	pending
10	104		accepted
11	106	210
12	102	211	pending
1	93	10	null
2	11	70	manual_review
3	95	25	failed
4	21	32	canceled
5	48	75	withdrawn
6	44	null	declined
7	74	85	processing
8	47	55	resubmitted
9	59	59	reopened
10	50	40	manual_review
11	84	41	declined
12	96	98	canceled
13	31	null	review_hold
14	72	81	failed
15	16	88	auto_declined
16	42	44	ignored

Expected Output

sender_id	accepted_requests	total_requests	acceptance_rate
103	2	2	1.0000

Practice SQL

PostgreSQL

Open on desktop for the full SQL editor with syntax highlighting and autocomplete.

Up next

Top Friend Request Acceptance RateEasy

Daily Friend Request Acceptance RateMedium

Top Meta Messengers Last 7 DaysEasy

Next question

Top Friend Acceptance Rate

Easy

SQL & Data Manipulation

Asked at 1 company1JoinsAggregationsCase When

Also asked at

Problem

Task

Write a SQL query to find the user with the highest acceptance rate, defined as:

accepted requests sent / total non-null-status requests sent

Requirements

Compute acceptance rate at the sender_id level.
Count only rows where status is not NULL in the denominator.
Treat status = 'accepted' as an accepted request.
Return the sender with the highest acceptance rate.
Include these output columns: sender_id, accepted_requests, total_requests, acceptance_rate.
Order by acceptance_rate descending, then sender_id ascending, and return the top row only.

Table Definition

friend_requests

column	type	description
request_id	INT	Unique request identifier
sender_id	INT	User who sent the friend request
receiver_id	INT	User who received the friend request
status	VARCHAR(20)	Request outcome such as accepted, declined, pending, or NULL

Sample Data

request_id	sender_id	receiver_id	status
1	103	201	accepted
2	101	202	declined
3	104	203	pending
4	101	204	accepted
5	102	205	accepted
6	103	206	accepted

Expected Output

sender_id	accepted_requests	total_requests	acceptance_rate
103	2	2	1.0000

Schema

friend_requests

Column	Type	Description
request_idPK	INT	Unique identifier for each friend request
sender_id	INT	Meta user who sent the request
receiver_id	INT	Meta user who received the request
status	VARCHAR(20)	Request status such as accepted, declined, pending, or NULL

friend_requests

request_id	sender_id	receiver_id	status
1	103	201	accepted
2	101	202	declined
3	104	203	pending
4	101	204	accepted
5	102	205	accepted
6	103	206	accepted
7	102	207	declined
8	105	208
9	101	209	pending
10	104		accepted
11	106	210
12	102	211	pending
1	93	10	null
2	11	70	manual_review
3	95	25	failed
4	21	32	canceled
5	48	75	withdrawn
6	44	null	declined
7	74	85	processing
8	47	55	resubmitted
9	59	59	reopened
10	50	40	manual_review
11	84	41	declined
12	96	98	canceled
13	31	null	review_hold
14	72	81	failed
15	16	88	auto_declined
16	42	44	ignored

Expected Output

sender_id	accepted_requests	total_requests	acceptance_rate
103	2	2	1.0000

Problem

Task

Write a SQL query to find the user with the highest acceptance rate, defined as:

accepted requests sent / total non-null-status requests sent

Requirements

Compute acceptance rate at the sender_id level.
Count only rows where status is not NULL in the denominator.
Treat status = 'accepted' as an accepted request.
Return the sender with the highest acceptance rate.
Include these output columns: sender_id, accepted_requests, total_requests, acceptance_rate.
Order by acceptance_rate descending, then sender_id ascending, and return the top row only.

Table Definition

friend_requests

column	type	description
request_id	INT	Unique request identifier
sender_id	INT	User who sent the friend request
receiver_id	INT	User who received the friend request
status	VARCHAR(20)	Request outcome such as accepted, declined, pending, or NULL

Sample Data

request_id	sender_id	receiver_id	status
1	103	201	accepted
2	101	202	declined
3	104	203	pending
4	101	204	accepted
5	102	205	accepted
6	103	206	accepted

Expected Output

sender_id	accepted_requests	total_requests	acceptance_rate
103	2	2	1.0000

Schema

friend_requests

Column	Type	Description
request_idPK	INT	Unique identifier for each friend request
sender_id	INT	Meta user who sent the request
receiver_id	INT	Meta user who received the request
status	VARCHAR(20)	Request status such as accepted, declined, pending, or NULL

friend_requests

request_id	sender_id	receiver_id	status
1	103	201	accepted
2	101	202	declined
3	104	203	pending
4	101	204	accepted
5	102	205	accepted
6	103	206	accepted
7	102	207	declined
8	105	208
9	101	209	pending
10	104		accepted
11	106	210
12	102	211	pending
1	93	10	null
2	11	70	manual_review
3	95	25	failed
4	21	32	canceled
5	48	75	withdrawn
6	44	null	declined
7	74	85	processing
8	47	55	resubmitted
9	59	59	reopened
10	50	40	manual_review
11	84	41	declined
12	96	98	canceled
13	31	null	review_hold
14	72	81	failed
15	16	88	auto_declined
16	42	44	ignored

Expected Output

sender_id	accepted_requests	total_requests	acceptance_rate
103	2	2	1.0000

Practice SQL

PostgreSQL

Open on desktop for the full SQL editor with syntax highlighting and autocomplete.

Up next

Top Friend Request Acceptance RateEasy

Daily Friend Request Acceptance RateMedium

Top Meta Messengers Last 7 DaysEasy

Next question