YipitData Interview Questions

YipitData Interview Guides

Click or hover over a slice to explore questions for that topic.
Data Structures & Algorithms
(32)
Machine Learning
(3)
Behavioral
(3)
Statistics
(2)
Product Sense & Metrics
(1)

YipitData Interview Questions

Practice for the YipitData interview with these recently asked interview questions.

QuestionTopicDifficulty
SQL
Hard

Given a table of product subscriptions with a subscription start date and end date for each user, write a query that returns true or false whether or not each user has a subscription date range that overlaps with any other completed subscription.

Completed subscriptions have end_date recorded.

Example:

Input:

subscriptions table

Column Type
user_id INTEGER
start_date DATETIME
end_date DATETIME
user_id start_date end_date
1 2019-01-01 2019-01-31
2 2019-01-15 2019-01-17
3 2019-01-29 2019-02-04
4 2019-02-05 2019-02-10

Output:

user_id overlap
1 1
2 1
3 1
4 0
Data Structures & Algorithms
Medium
Data Structures & Algorithms
Easy
Loading pricing options

View all Yipitdata questions

Challenge

Check your skills...
How prepared are you for working at Yipitdata?

YipitData Salaries by Position

Software Engineer*
$121K
$139K
Software Engineer
Median: $130K
Mean (Average): $130K
Data points: 2

Most data science positions fall under different position titles depending on the actual role.

From the graph we can see that on average the Software Engineer role pays the most with a $130,000 base salary while the Software Engineer role on average pays the least with a $130,000 base salary.

Discussion & Interview Experiences

?
There are no comments yet. Start the conversation by leaving a comment.