Back to problems

Last-Mile Business Queries (Aggregations, Joins, Windows, Dates, Optimization)

SQL · Walmart Labs · Hard

Prompt: SQL Live Coding (Last-Mile and E-commerce Scenarios) During the interview, you will generally work with multiple tables describing orders and delivery operations, such as orders, order_items, deliveries, and customers. When a definition is unclear, ask clarifying questions before solving 2–4 SQL exercises drawn from the categories below. Type A: GMV/Revenue calculations Calculate GMV or revenue over a specified period, confirming whether taxes, delivery charges,…

Checking your access…