Problem 3 of 5 · Percentiles & medianNext: Interpolated vs actual median per status

00:00

Practice / SQL / Percentiles & median

WorkingGuided

MediumAbout 7 minPercentiles & median

Price quartiles (p25, p50, p75) per category

For each product category, return the 25th, 50th, and 75th percentile of list_price as continuous percentiles — linearly interpolated between neighbouring prices, so a percentile can fall between two products.

Sort by category ascending.

Returncategoryp25p50p75

Columns

products3 columns

columntype

product_idVARCHAR

categoryVARCHAR

list_priceBIGINT

The table

6 rows · 3 columns

productsfirst 5 of 6 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