85. Top 4 queries based on click through rate on new year's day

Upgrade to practice this Facebook coding question.

A paid plan gives you access to our coding interview questions, courses on SQL, Python and Machine Learning. As well as AI career copy writing, resume services.

🔥 Get My Dream Job Offer

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

*****************************************************************************************************************
**************************************************(>2)****************
**********************************************************************

Table 1: search


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

Table 2: search_result


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

Sample results

Last Submission postgres

Expected results

Your results

More Facebook questions

ID	Title	Level	FTPR
81	How many people searched on new year's day facebook	easy	24%
82	The top search query on new year's day facebook	easy	13%
83	Top search_query in US and UK on new year's day facebook	medium	6%
84	Click through rate on new year's day facebook	medium	9%
96	Overall acceptance rate facebook	easy	13%
97	Social influencer facebook	easy	10%
98	Most popular user facebook	easy	33%
99	Page recommendation facebook	medium	13%
100	Advertiser ROI facebook	medium	8%
172	Comments distribution facebook	hard	13%
173	User Popularity Percentage facebook	medium	11%
174	Closed accounts facebook	easy	23%