Menu▾

Company

Shopee SQL questions

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.

easyConversion rate per variantFree→easyOrders by statusFree→mediumCustomers who never orderedBasic→mediumLink orders to customers with an enforced, cascading foreign keyFree→mediumNovelty effect over four weeksFree→hardRunning total of daily salesFree→hardSplit customers into spending quartilesBasic→

Company 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.