Filter then sort a threshold

Business context

An advisor prepares a selection of references above a budget threshold given by his client. Your answer must be verifiable by another person: respect the level of detail requested, use explicit aliases and control the number of records returned before drawing a business conclusion. The data is fictitious and is used for learning purposes only.

Skills practised

• WHERE
• Interpreting the result
• Checking the level of detail

Available tables

Your task

Show product and price for products costing at least 50 TND, from most expensive to least expensive.

Build your reasoning

1. Rephrase the mission and its level of detail: Display product and price for products costing at least 50 TND, from most expensive to least expensive.
2. Locate the necessary columns in products before applying WHERE · ORDER BY.
3. First build the structure that must return product, price, then add the filters or calculations.
4. Check the 4 expected lines and explain a value with the source data.

SELECT produit, prix
FROM produits
WHERE -- inclusive threshold
ORDER BY -- sorting;

Expected result

Explained answer