Select the correct columns

Business context

A catalog team prepares an export intended for a comparison page. It needs the business name and price, but not the technical identifiers or category. Explicitly choosing the columns reduces noise and stabilizes the contract between the query and the screen that consumes its result.

Skills practised

• Precisely define output columns
• Respect the order requested by the recipient
• Avoid SELECT* in a query intended for reuse

Available tables

Your task

From the Products table, display the Product and Price columns, in that order.

Build your reasoning

1. First locate the requested table: products.
2. Transform each expected piece of information into a column name: product then price.
3. Place these columns after SELECT in the order of the expected result.
4. Check that the query returns three rows and exactly two columns.

SELECT
  -- columns to choose
FROM produits;

Expected result

Explained answer