How do you join two tables by a common value in SQL?
Data Intern Interview Questions
7,487 data intern 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.
Python and SQL coding questions
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.
1. Why Seismic 2. Questions on Past experiences 3. Questions regarding the previous projects 4. A lot of follow-up questions and questions based on my resume!
Take us through how you clean and prepare data
Viewing 7081 - 7090 interview questions