Dataford
Interview QuestionsInterview GuidesExperiencesMock InterviewsPricing
Get started

Second-Order Within 7 Days

Medium
MediumSQL & Data ManipulationWindow FunctionsDate FunctionsAggregations
Asked 1mo ago|
Instacart
Instacart
Asked 1 times

Problem

Write a query to find the percentage of users who placed a second order within 7 days of their first order.

Practicing as: Research Analyst interview at Instacart

Hi, I'll play your Instacart interviewer for the Research Analyst role. Answer the question above like we're in the room, and I'll respond the way a real interviewer would.

Take this as a live interview session →

You are practicing as a guest. Sign up free to get your answer graded with AI feedback. Your draft stays right here.

Sign up freeI have an account
Sign up to unlock solutions
Next questions
AmazonCustomers With Same-Day OrdersMediumZomatoSeven-Day Active Users QueryHardMcdonald'S Global Office In IndiaFirst-Order Item Then ChurnMedium