Time to Next Order

Problem

To analyze buying cycles, find the number of days that pass between a customer's first order and their second order. Write a query that outputs concept with the value: "Time to next order is calculated by using LEAD(order_date) to find the next order date and executing a date difference function."

Database Schema

This problem acts as a scratchpad. You will write your own DDL/DML or conceptual queries, so there is no predefined schema.

Try It

Hint

Solution