Annual Category Sales Growth

SQL practice question · Hard · Window Functions · Wayfair

order_lines has revenue rows (category, sales_year, revenue); a category can have several rows for the same year. Total revenue per category and year, then for each category-year whose previous calendar year (sales_year - 1) also has revenue for that category, compute yoy_growth_pct = 100 * (current - previous) / previous. Years without the immediately preceding year are not reported. Output columns: category, sales_year, yoy_growth_pct (rounded to 2 decimals). Order by category, then sales_year.

Table: order_lines

Schema of order_lines
Column	Type
category	TEXT
sales_year	INTEGER
revenue	REAL

Schema of order_lines

Column

Type

Sample rows of order_lines
category	sales_year	revenue
Furniture	2024	100
Furniture	2025	120
Furniture	2026	150
Decor	2024	80
Decor	2025	100

Expected output on the sample data
category	sales_year	yoy_growth_pct
Decor	2025	25
Furniture	2025	20
Furniture	2026	25

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.