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.

What difficulty level is this interview question?

This is a Medium difficulty Coding & Algorithms question, commonly asked during Onsite rounds at Instacart.

What role is this question designed for?

This question is commonly asked for Software Engineer candidates at Instacart during technical interviews.

Compute immediate delivery percentage

Last updated: Mar 29, 2026

Quick Overview

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.

Instacart

Aug 4, 2025, 10:55 AM

Software Engineer

Onsite

Coding & Algorithms

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/

Comments (0)

Loading comments...

Browse More Questions

More Coding & Algorithms•More Instacart•More Software Engineer•Instacart Software Engineer•Instacart Coding & Algorithms•Software Engineer Coding & Algorithms