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 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?
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.
This is one of easy level Microsoft data science interview questions that mainly tests if you understand how to de-duplicate data.