📌 LeetCode - 1174: Immediate Food Delivery II | SQL 50 Series | Easy
In this problem, you are given a table Delivery that contains information about customer food orders, including the order date and the customer’s preferred delivery date.
Your task is to determine the percentage of customers whose first order was delivered immediately, meaning the order date is the same as the preferred delivery date.
🔍 What You Need to Do:
Identify each customer's first order.
Check whether that order was an immediate delivery:
Immediate = order_date = customer_pref_delivery_date
Calculate the percentage of such customers out of all customers.
#LeetCode #SQL #SQL50 #Database #Coding #Programming #DataAnalytics #LearnSQL #InterviewPrep #CodingInterview #Tech #java
#javaprogramming
#leetcodequestions
#leetcodesolution
#leetcodedailychallenge
#leetcodechallenge
#leetcodejavasolutions
#leetcodearraysproblem
