Compute immediate delivery percentage

Q: Compute immediate delivery percentage

This question evaluates proficiency in SQL querying, including aggregation, date-based filtering, percentage calculation with rounding, and the ability to identify first-ever orders per customer.

Q: How do I approach Coding & Algorithms interview questions?

Coding & Algorithms questions require understanding of core concepts and practice. PracHub provides solutions with explanations to help you master coding & algorithms interviews.

Question

Question

LeetCode 1173. Immediate Food Delivery I – Write an SQL query to calculate the percentage of immediate (same-day) orders, rounded to two decimals. Follow-up (LeetCode 1174. Immediate Food Delivery II) – Extend the query to compute the percentage of immediate first-ever orders for each customer.

https://leetcode.com/problems/immediate-food-delivery-i/description/ https://leetcode.com/problems/immediate-food-delivery-ii/description/

Compute immediate delivery percentage

Question

Comments (0)