Dataford
Interview QuestionsInterview GuidesExperiencesMock InterviewsPricing
Get started

Login-to-Ticket Time Calculation

Hard
HardSQL & Data ManipulationLag/LeadDate FunctionsJoinsAsked 1 times

Problem

Given a table of customer support tickets and a table of user logins, how would you calculate the average time between a failed login and a submitted ticket?

Practicing as: Customer Insights Analyst interview at Rippling

Hi, I'll play your Rippling interviewer for the Customer Insights 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
Rippling Customer Insights Analyst Interview Questions
Next questions
SeatgeekSQL for Avg Time Between PurchasesMediumFreshworksSQL Ticket Average ResolutionEasyFaireCompute Time to First PurchaseMedium