Compute dasher payout from API data

Q: How do I practice SQL interview questions?

PracHub provides an interactive SQL console where you can write and test queries against real database schemas. Get instant feedback and compare your solution with the expected output.

Q: What difficulty level is this coding question?

This is a medium difficulty Data Manipulation (SQL/Python) question, commonly asked during Onsite rounds at DoorDash.

Q: What role is this question designed for?

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

Question

Given a REST endpoint GET /payout that returns each delivery’s components (base pay, distance/time bonuses, promotions, tips, fees, adjustments, taxes, refunds) with timestamps, compute each Dasher’s total pay for a pay period. Handle pagination, missing/late events, time zones, partial-day boundaries, cancellations/chargebacks, negative adjustments, and rounding rules. Provide a Python or SQL implementation that aggregates per Dasher and outputs totals and itemized breakdowns; include test cases and discuss complexity.

PracHub · Accepted Answer

This question evaluates a candidate's proficiency in data manipulation and transaction aggregation using SQL or Python, encompassing time-zone-aware timestamp handling, pagination, late or missing events, cancellations and negative adjustments, rounding rules, and itemized breakdowns.

Quick Overview

Compute dasher payout from API data