SELECT indicates the columns to return and FROM the table they come from. It is the basis of all data reading in SQL. SELECT * returns all columns, but explicitly naming the useful columns is clearer and more efficient.
Example
SELECT nom, prix FROM produits;