What are window functions in SQL and their types? Questions related to SQL window functions asked by Airbnb, Netflix, Twitter, and Uber.
This interview question for a data scientist position was asked by Facebook during an interview. Technically, this question leverages SQL concepts.
SQL Window Functions Interview Questions are common in data science and analytics interviews as data scientists handle time series data on a daily basis.
This data science interview question was asked by Facebook during a data science interview. It asks the interviewee to calculate the friend acceptance rate.
Advanced Amazon data scientist interview questions that will test your date manipulation and formatting skills as well as your window function knowledge.
This Microsoft data scientist interview question has a complex solution that involves multiple SUB QUERIES and a LEFT JOIN to calculate a percentage.
The SQL solution for this Yelp data science interview question is easy to implement but there’s a tricky assumption most people get wrong. Can you spot it?
Understanding 5 coding concepts of data science coding interview questions that companies will test you on and preparing for them effectively.
The most common data science interview questions that cover several technical concepts that you'd use every day on the job.
This is one of the important Facebook data analyst interview questions that is asking to find out the most active users on Facebook Messenger.
The question is a hard question because it requires several manipulations of the data that results in 2 SUBQUERIES that help create new aggregate columns.
One of the medium difficulty data scientist analytics interview questions from Facebook that requires a function to check a 'search term' in a column.
This Microsoft SQL interview question has multiple steps including applying a LEFT JOIN, using a CASE WHEN, and using the SQL sum() function.
This is one of easy level Microsoft data science interview questions that mainly tests if you understand how to de-duplicate data.