SQL Question Bank for Category Interviews

If you are prepping for a category manager or e-commerce management role at Flipkart, Amazon, Meesho, Blinkit, Zepto, Instamart, Noon, or Nykaa, the SQL round is where most candidates lose the offer. Not because they cannot write SQL, but because they cannot translate a category question into a query fast enough.

This bank fixes that.

30 questions built specifically for category interviews. Not generic employee-salary or department-average questions. Every question is set in a real category context: GMV, ASP, return rate, cohort retention, fill rate, RU%, NS GMV %, ROAS, brand share, hero SKU concentration. The tables and the questions look and feel like what interviewers actually ask.

What is inside:

1. 30 questions split as 60% Easy, 30% Medium, 10% Hard, mirroring how real interviews scale up
2. Every question tagged by the company where it (or its close variant) is commonly asked
3. Complete SQL answers using ANSI syntax, with syntax quirks flagged for Presto (Flipkart), Redshift (Amazon), and Postgres
4. A "What to Say Out Loud" note on every answer, so you know what to verbalise in the interview to signal you are thinking, not memorising
5. A one-line approach hint before each SQL block, so you can attempt the question cold before reading the answer

Who this is for:

Aspiring category managers, MBA students, and 1 to 5 year professionals targeting category or e-commerce roles at Indian marketplaces, quick commerce, and D2C brands.

Not for: Data engineers, analytics specialists, or anyone prepping for pure data roles. This is category-flavoured SQL, not full data structures and algorithms.

Note: Knowing SQL is not a mandate in every company, so read the Job Description first.

Built by Sanchit Goyal, Category Manager at Flipkart, MDI Gurgaon '22, ex-Zomato, and founder of the Category Decoded community.