Second Measure Interview Questions

Second Measure 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)

Second Measure Interview Questions

Practice for the Second Measure 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 Second measure questions

Challenge

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

Discussion & Interview Experiences

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

Discussion & Interview Experiences

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

Jump to Discussion