Write a query to return the user's id with the most friends. Hint:We can assume there is one and only one person with the most friends, there is no tie. A request can be accepted multiple times.

Question 97

Social influencer

Unsolved Easy facebook Lecture

Premium Access

***** * ***** ** ****** *** ****'* ** **** *** **** *******.
****:** *** ****** ***** ** *** *** **** *** ****** **** *** **** *******, ***** ** ** ***.
* ******* *** ** ******** ******** *****.

Table: accepted_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%
#98. Most popular user	Easy	33%
#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%