An exhaustive walkthrough to a hard-level SQL question involving windows functions, PARTITION BY clauses, CASE statements, and Common Table Expressions.
This Facebook python interview question will test your ability to use joins, perform transformations and calculations, and address edge-case scenarios.
In this post we'll take a close look at one of the PayPal data scientist interview questions and discuss two different ways of solving this question using SQL.