77. Deserts of Silence
Xorthax wants to measure the barren stretches of time between a customer’s visits.
Xorthax suspects some of his customers take long breaks between orders. For each customer, find the longest amount of time (in days) between two consecutive orders.
Write Your Query
Ace the Data Science Interview
Comprehensive prep for data interviews: SQL, stats, product sense, and case studies.
(Affiliate link – as an Amazon Associate I earn from qualifying purchases.)