Problem 2 of 18 · Window Functions & RankingNext: Show each product's current price on every price change

00:00

Practice / SQL / Window Functions & Ranking

WorkingGuided

EasyAbout 5 minWindow Functions & RankingLesson: Window Functions & Ranking (P15) →

Top product per category by price

Find the priciest product per category — the "flagship" SKU. Return one row per category. If two products tie for the top price, return the one with the smaller product_id.

Sort by category ascending.

Returncategoryproduct_idlist_price

Columns

products3 columns

columntype

product_idVARCHAR

categoryVARCHAR

list_priceBIGINT

The table

7 rows · 3 columns

productsfirst 5 of 7 rows

product_idcategorylist_price

p_001electronics500

p_002electronics150

p_003books20

p_004books35

p_005clothing45

If you get stuck

Show hint · 1 hint Walkthrough Reveal answer

Your query · runs in your browser⌘ Enter to run

Loading editor…

Output · run to see rows