Browse by company
Questions by company
The question bank, grouped by the company each scenario is themed around.
Grab
Ride-hailing, deliveries and payments in one warehouse — so these questions join trip-level tables to drivers, merchants and promos. Expect window functions for ranking and running totals, and questions where the trap is silently dropping cancelled trips.
8 questionsShopee
Marketplace-operations data — orders, sellers, listings and campaign performance. Questions here favour aggregation with conditions attached, and the recurring theme is getting a per-seller or per-category rollup right when the raw table is one row per order line.
7 questionsAirAsia
Airline data is schedule-shaped: bookings, flights, routes and fares, all with dates attached. These questions lean on date arithmetic and on the difference between a booking and a flown segment — a distinction that quietly changes the answer if you skip it.
5 questionsGXBank
A digital bank's tables are transaction ledgers plus customer state, so the questions are about balances, transfers and account lifecycle. The recurring skill is aggregating a ledger correctly and handling customers whose activity is missing rather than zero.
4 questionsLazada
Lazada-themed questions cover catalogue and order data across a regional marketplace — pricing, categories, sellers and returns. Several are the commodity classics (second-highest, month-over-month), framed on e-commerce tables rather than toy data.
4 questionsMaybank
Retail-banking scenarios: accounts, transactions, branches and products. These reward careful joins to reference tables and correct handling of customers with no matching rows, which is where an INNER JOIN quietly deletes part of your answer.
4 questionsTraveloka
Travel-booking data joins users to bookings to inventory across hotels and flights, usually with a funnel or conversion angle. Expect questions where the denominator is the hard part, not the numerator.
3 questionsCompany names are trademarks of their respective owners, used here only to describe practice material. mahir_data is not affiliated with, endorsed by, or sponsored by any company named on this site. Terms.