Order Items With Quantity At Least 6

List order items with quantity at least 6, including the product name. Return columns: order_id, product_name, quantity, unit_price. Order results by: oi.quantity DESC, oi.id.

Preparing the interactive SQL workspace...

Challenge overview

What you will practice

List order items with quantity at least 6, including the product name. Return columns: order_id, product_name, quantity, unit_price. Order results by: oi.quantity DESC, oi.id.

Difficulty: Advanced
SQL concept: INNER JOIN