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.

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.