Order Items With Quantity At Least 7

List order items with quantity at least 7, including the product name. Return columns: order_id, quantity, unit_price, product_name. 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 7, including the product name. Return columns: order_id, quantity, unit_price, product_name. Order results by: oi.quantity DESC, oi.id.

Difficulty: Advanced
SQL concept: INNER JOIN

This Pro challenge keeps its schema, dataset and solution behind subscription access. No protected answer content is included in public SEO data.