Top Suppliers' Share of Category GMV

SQL practice question · Medium · Aggregation · Meesho

Ignore cancelled orders (is_cancelled = 1). For each category compute every supplier's GMV and its share of the category's GMV: pct_of_category = 100 * supplier GMV / category GMV, ROUND to 2. Keep only the top 2 suppliers per category by GMV (ties: smaller supplier_id first). Return category, supplier_id, supplier_gmv (ROUND to 2) and pct_of_category. Order by category, supplier_gmv DESC, supplier_id.

Table: supplier_sales

Schema of supplier_sales
Column	Type
order_id	INTEGER
supplier_id	TEXT
category	TEXT
gmv	REAL
is_cancelled	BOOLEAN

Schema of supplier_sales

Column

Type

order_id

INTEGER

supplier_id

TEXT

Sample rows of supplier_sales
order_id	supplier_id	category	gmv	is_cancelled
1	S10	Sarees	1200	0
2	S11	Sarees	800	0
3	S10	Sarees	300	0
4	S12	Sarees	700	0
5	S11	Sarees	500	1
6	S20	Kurtis	400	0
7	S21	Kurtis	600	0
8	S20	Kurtis	100	0

Expected output on the sample data
category	supplier_id	supplier_gmv	pct_of_category
Kurtis	S22	900	45
Kurtis	S21	600	30
Sarees	S10	1500	50
Sarees	S11	800	26.67

Company-wise SQL questions

{{ totalCount }} questions in the style asked at Amazon, Microsoft, Google, Meta, Flipkart and more — {{ hardPct }}% Hard. Write SQL in a real database engine in your browser, run it on sample data, then evaluate against hidden tests.

🏆 Weekly SQL Contest

Questions

Companies

Solved

Bookmark Question Companies Difficulty Category Status

{{ r.n }} - {{ r.title }}

No questions match these filters.

Showing {{ rangeLabel }} of {{ filteredCount }}

Company tags show where this type of question is commonly reported in interviews. Questions, data and solutions are written by TechTown.

Daily challenge

{{ daily.title }} · {{ daily.difficulty }} Solve now

New question every day at midnight IST.

Your Progress

Reset all SQL practice progress{{ resetScope }}? This can't be undone.

{{ p.label }} ({{ p.pct }}%){{ p.solved }}/{{ p.total }}

Points: {{ myPoints }} · Easy 10 · Medium 20 · Hard 40

🔥 Longest streak: {{ streak.longest }}Current streak: {{ streak.current }}

Leaderboard (rolling 100 days)

Loading…

{{ u.rank }} {{ u.name }}{{ u.points }} pts

← All questions

{{ cur.n }} - {{ cur.title }}

🏆 Contest {{ contestWeek }}

Embed this questionPaste on a blog, course page or LMS. Free to use — educator guide

{{ embedCode }}

Table: {{ tb.name }}

ColumnType

Expected output on the sample data:

No submissions yet. Press Evaluate to submit your query.

The solution unlocks after you solve this question or after 3 evaluations that didn't pass ({{ failCount }}/3 so far). Trying first is the fastest way to learn.

{{ solutionSql }}

SQL dialect ⏱ {{ timerLabel }}

{{ fnHelpTitle }}
{{ fnHelpText }}

Writing {{ dialectName }} · Ctrl/Cmd + Enter runs the query · Tab indents · your code is saved automatically

Output

{{ out.error }}

Expected (sample data)

Your output (sample data)

Run your query to see the result here.

🔒

To Track Your Progress, Log In / Sign Up

You have solved your 3 free questions — nice work! Log in (free) to unlock all 150 questions, keep your streak and appear on the leaderboard.