← All practice problems

Top 3 line items per order by list-price value

working · sql🔒Walkthroughs

NEW

Top 3 line items per order by list-price value

For each order, return its top 3 line items by line value — where line value is qty * products.list_price (NOT the order_items.unit_price column; you need the join).

Tie-break on product_id ascending if two items in the same order tie on value.

Columns: order_id, product_id, line_value, item_rank. Sort by order_id then item_rank ascending. Items beyond top 3 per order don't appear.

Tables & sample data

order_items

Loading preview…

products

Loading preview…

query.sql

Loading…

Loading editor…