Filter and sort orders

Business context

The sales department wants to examine as a priority orders whose amount exceeds €50. The descending ranking allows it to start with the most important files. This query separates two responsibilities: WHERE defines the scope and ORDER BY organizes only the retained rows.

Skills practised

• Translate a business threshold into a predicate WHERE
• Choosing between strict superior and superior or equal
• Produce a repeatable order with ORDER BY

Available tables

Your task

Show id_commande and amount for orders over €50. Sort the result by descending amount.

Build your reasoning

1. Identify the relevant numeric column: amount.
2. The word exceed imposes the strict > operator, so an order of €50 would be excluded.
3. Request a sort on this same column with DESC.
4. Verify that 134 precedes 89 and that 45 does not appear.

SELECT id_commande, montant
FROM commandes
WHERE -- your filter
ORDER BY -- your sorting;

Expected result

Explained answer