Leetcode Problem 1174. Immediate Food Delivery II

1174. Immediate Food Delivery II

Leetcode Solutions

Group the Delivery table by customer_id and select the minimum order_date for each customer to identify their first order.
Join this result back to the original Delivery table to filter out only the first orders for each customer.
Use a CASE statement to determine if each first order is immediate by checking if order_date equals customer_pref_delivery_date.
Calculate the average of the immediate flags (1 for immediate, 0 for scheduled) to get the percentage of immediate first orders.
Multiply the average by 100 to convert it to a percentage format.
Round the result to two decimal places.
Select the rounded result as immediate_percentage.


erDiagram
    Delivery {
        int delivery_id PK
        int customer_id
        date order_date
        date customer_pref_delivery_date
    }

Programming Language

Purpose:

General Question

Debug My Code

image/screenshot of info(optional)

Full Screen