Analyze food-delivery data
Company: Coinbase
Role: Software Engineer
Category: Coding & Algorithms
Difficulty: Medium
Interview Round: Onsite
##### Question
Food-delivery analytics tasks (three sub-questions).
Given many restaurants and their menus, return the restaurant offering the lowest total price for an order and the one geographically closest to the user.
Given menu item prices and a list of orders, compute the total price, order count, and average order value over a time window.
Over the same time window, return
(a) the Top-K orders by total price and
(b) the Top-K menu items by sales volume.
Quick Answer: This question evaluates algorithmic problem-solving and data-processing competencies, including aggregation, time-window analytics, top-K selection, and geospatial proximity reasoning, within the Coding & Algorithms domain.