Hard
INNER JOIN
Pro Challenge

Order Items With Quantity At Least 4

List order items with quantity at least 4, 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 4, 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