Write a query to return the user who received the most friend requests in January 2021. Hint: We can assume there is one and only one person with the most requests, there is no tie. Requests from the same sender should be deduplicated when counting.

Question 98

Most popular user

Unsolved Easy facebook Lecture

Premium Access

***** * ***** ** ****** *** **** *** ******** *** **** ****** ******** ** ******* 2021.
****: ** *** ****** ***** ** *** *** **** *** ****** **** *** **** ********, ***** ** ** ***.
******** **** *** **** ****** ****** ** ************ **** ********.

Table: friend_request

****** ******* *****

  ***_****    | ***_****
--------------+--------------------------
 ******_**    | ******
 *********_** | ******
 *******_**   | ****

Sample results

Last Submission

postgres

No submission yet for this engine. Run and submit your query to save it here.

Expected results

Submit a query to compare against expected output.

Engine

Interview timer

Recommended interview pacing

Easy: 5 min for direct warm-up style questions.

Medium: 10 min for multi-step interview queries.

Hard: 15 min for layered questions with tighter time pressure.

A common bar is solving about 2 medium-or-harder questions in a 30 minute interview.

5:00

Timer

Your results

Run your query to preview results here.

Question	Level	FTPR
#81. How many people searched on new year's day	Easy	24%
#82. The top search query on new year's day	Easy	13%
#83. Top search_query in US and UK on new year's day	Medium	6%
#84. Click through rate on new year's day	Medium	9%
#85. Top 4 queries based on click through rate on new year's day	Hard	7%
#96. Overall acceptance rate	Easy	13%
#97. Social influencer	Easy	10%
#99. Page recommendation	Medium	13%
#100. Advertiser ROI	Medium	8%
#172. Comments distribution	Hard	13%
#173. User Popularity Percentage	Medium	11%
#174. Closed accounts	Easy	23%