This Leetcode problem Immediate Food Delivery I LeetCode Solution is done in SQL.
List of all LeetCode Solution
![Immediate Food Delivery I LeetCode Solution](https://i0.wp.com/totheinnovation.com/wp-content/uploads/2024/02/LeetCode-Problem-Solution.png?resize=200%2C200&ssl=1)
Immediate Food Delivery I LeetCode Solution
Table of Contents
Problem Statement
Column Name | Type |
delivery_id | int |
customer_id | int |
order_date | date |
customer_pref_delivery_date | date |
delivery_id is the primary key of this table.
The table holds information about food delivery to customers that make orders at some date and specify a preferred delivery date (on the same order date or after it).
If the customer’s preferred delivery date of the customer is the same as the order date, then the order is called immediate otherwise it’s called scheduled.
Write an SQL query to find the percentage of immediate orders in the table, rounded to 2 decimal places.
The result format is in the following example.
Example 1:
Input:
delivery_id | customer_id | order_date | customer_pref_delivery_date |
1 | 1 | 2019-08-01 | 2019-08-02 |
2 | 2 | 2019-08-02 | 2019-08-02 |
3 | 1 | 2019-08-11 | 2019-08-12 |
4 | 3 | 2019-08-24 | 2019-08-24 |
5 | 3 | 2019-08-21 | 2019-08-22 |
6 | 2 | 2019-08-11 | 2019-08-13 |
7 | 4 | 2019-08-09 | 2019-08-09 |
Delivery table:
<strong>Output:</strong>
Code language: HTML, XML (xml)
immediate_percentage |
33.33 |
<strong>Explanation:</strong> The orders with delivery id 2 and 3 are immediate while the others are scheduled.
Code language: HTML, XML (xml)
Immediate Food Delivery I LeetCode Solution MySQL
select
round(
(
select
count(*)
from
Delivery
where
order_date = customer_pref_delivery_date
) / (
select
count(*)
from
Delivery
) * 100,
2
) as immediate_percentage;
Code language: SQL (Structured Query Language) (sql)
Immediate Food Delivery I LeetCode Solution MySQL (Another approach)
select
round(
sum(
case when order_date = customer_pref_delivery_date then 1 else 0 end
) / count(delivery_id) * 100,
2
) as immediate_percentage
from
Delivery;
Code language: SQL (Structured Query Language) (sql)