This SQL data science interview question was asked by Facebook. I’ll cover both the question and answer and give a detailed explanation of the approach. I walkthrough each step of my answer, assumptions, approach, and explain every line of code I write. This is literally how I would answer every data science interview question and prepare for every data science interview at FAANG companies and others.
Link to the question: [ Ссылка ]
The question asks the interviewee to calculate the friend acceptance rate over time, which basically means you need to calculate a rate and group it by date. Technically, this question leverages SQL concepts like LEFT JOIN, GROUP BY, SUBQUERIES, and data type conversions from INT to FLOAT or DECIMAL. This question covers concepts that are commonly found in data science interviews at Facebook and Google.
______________________________________________________________________
This series is for both beginner and intermediate data scientists and analysts interested in learning how to solve common data science interview questions in SQL. These are real data science interview questions. For some background context and an intro about what this series is about: [ Ссылка ]
👉 Subscribe to my channel: [ Ссылка ]
👉 Playlist for more data science interview questions and answers: [ Ссылка ]
👉 Playlist for data science interview tips: [ Ссылка ]
👉 Practice more real data science interview questions: [ Ссылка ]
______________________________________________________________________
Links:
If you want more SQL or python interview practice with real data science interview questions, visit [ Ссылка ].
There are over 500+ data science interview questions where you can write and run code for free. If you want to see our solutions or solutions from others, you can use ss15 for a 15% discount on the premium plans.
______________________________________________________________________
Contact:
If you have any questions or comments, please leave them here!
Or email me at nathan@stratascratch.com.
______________________________________________________________________
