Section 02 : Basic Agg : part 03 - P7

Farahat612 · Farahat612 · commit ac5ac5817243 · 2024-04-06T23:59:19.000+02:00
diff --git a/3. Basic Aggregate Functions/07 1174. Immediate Food Delivery II.sql b/3. Basic Aggregate Functions/07 1174. Immediate Food Delivery II.sql
@@ -0,0 +1,11 @@
+SELECT ROUND (
+  AVG(
+    CASE WHEN order_date = customer_pref_delivery_date THEN 1 ELSE 0 END
+    ) * 100 , 2) AS immediate_percentage
+FROM Delivery
+WHERE (customer_id, order_date) IN
+(
+    SELECT customer_id, min(order_date) 
+    FROM Delivery 
+    GROUP BY customer_id
+)
