The Washington Post Interview Questions

The Washington Post Interview Guides

Click or hover over a slice to explore questions for that topic.
Data Structures & Algorithms
(25)
Machine Learning
(15)
Behavioral
(8)
Analytics
(8)
SQL
(7)

The Washington Post Interview Questions

Practice for the The Washington Post 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
SQL
Medium
SQL
Hard
Loading pricing options

View all The Washington Post questions

Challenge

Check your skills...
How prepared are you for working at The Washington Post?

The Washington Post Salaries by Position

$95K
$166K
Software Engineer
Median: $146K
Mean (Average): $138K
Data points: 17

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 $138,426 base salary while the Software Engineer role on average pays the least with a $138,426 base salary.

Discussion & Interview Experiences

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