Company SQL Question
Customer Order Frequency Analysis
Practice this Amazon style SQL interview question with live execution and instant feedback.
Problem Statement
Analyse inter-order gap days for repeat customers using LAG() and two CTEs.
Relevant Tables
orderscustomers
SQL Concepts Used in This Question
Strengthen your understanding with these targeted learning topics: