Given a revenue transaction table that contains user_id, timestamp, and revenue, how would you find the third purchase of every user?
Data Interview Questions
132,711 data interview questions shared by candidates
Product Sense, Data Modeling, SQL, Python, Ownership
Complete a function that returns a list containing mismatched words in two strings. The return list can be in any order. I used set to solve this question, but was also asked to verbally explain how I would solve it without using sets.
given a table massenger_sends, date | ts | sender_id | receiver_id| message_id | has_reaction Q1) how many unique conversation threads are there ? note that there are threads that sender_id and receiver is inverse. this should be one thread
Question 2: What are the top five (ranked in decreasing order) single-channel media types that correspond to the most money the grocery chain had spent on its promotional campaigns?
What is probability of getting one pair of card from 52 deck of cards? How would you improve work hours?
Nothing difficult. Some people found difficult the questions about how to get along with colleagues and how to create a good relationship or break the ice.
For a given array count combination of pairs of (x,y) whose sum is N.
They asked me to do a Excel Test, without telling me beforehand of it.
What's 5/2 in MySQL ?
Viewing 211 - 220 interview questions