Consecutive Order Days

Write a SQL query to find the date range (first and last order date) for each customer.

Expected Columns

• customer_name
• first_order
• last_order
• days_as_customer

Example Output

| customer_name | first_order | last_order | days_as_customer | |---------------|-------------|------------|------------------| | Rajesh Kumar | 2023-01-20 | 2023-04-20 | 90 | | Sunita Devi | 2023-01-25 | 2023-03-10 | 44 | | ... | ... | ... | ... |