How do you join two tables by a common value in SQL?
Intern Data Scientist Interview Questions
3,779 intern data scientist interview questions shared by candidates
There were mostly questions concerning SQL and product sense: some easy technical questions like 'What commend would you use to sort results in descending order?' and 'What types of joins are there?', as well as two not difficult coding problems where I had to join tables, filter out some rows, group filtered ones and order results; when it comes to product sense, that part was quite difficult: they asked what metrics would you use to find out if two users are friends in real life and how would you find out if some user has more real-life friends than not-real-life among his friends on facebook.
- Operator that combines and returns the result-set (rows) retrieved by two or more select statements? - How would you determine the customer service quality of Facebook Marketplace B2B2C through the chatbox? - Some basic AVG() SQL question - Learn how to use SQL CTE for basic aggregate functions
querying a database using SQL
Figure out who is friends from profile.
What can you gather from peoples data to get people to go on social media
I was asked to describe one of my projects with coding. Machine learning questions were based on the basic concepts in the relevant areas.
Create a programme that can tell if a review for something is negative or positive.
Was never offered the opportunity to interview
How to merge data frames? What is the difference between different types of merges? Investigate a dip in users of a new product (don’t remember exactly)
Viewing 3581 - 3590 interview questions