Minutes from order to doorstep

SQL

Minutes from order to doorstep

Instacart SQL Interview Question
hardPremium

About this question

A hard SQL question from Instacart data analyst and business analyst interviews about the time between two status events on one order. It tests timestamp arithmetic, event log analysis and duration between events.

The full question, its data and the solution are part of Premium, along with every other question in the library.

  • The full question and its datasets
  • The editor with instant grading
  • A worked solution and common mistakes