Largest 6 Orders

Return the 6 orders with the highest totals, including customer names. Return columns: order_id, total_amount, customer_name. Order results by: o.total_amount DESC, o.id.

Preparing the interactive SQL workspace...

Challenge overview

What you will practice

Return the 6 orders with the highest totals, including customer names. Return columns: order_id, total_amount, customer_name. Order results by: o.total_amount DESC, o.id.

Difficulty: Intermediate
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.