Every SQL query starts with SELECT. You say which columns you want, then FROM which table. SELECT * returns every column, which is handy for a first look at a table, but at work you'll usually list the columns you need, separated by commas.
You can also calculate new columns: price - cost works out the profit on each product. Give a calculated column a readable name with AS, as in price - cost AS profit. Without a name, the database invents one from the expression.
SQL keywords aren't case-sensitive, so select and SELECT both work. Writing keywords in capitals is a common habit because it makes queries easier to scan. The semicolon at the end is optional when you run one query.
The first table you'll use is products: everything Kestrel, an online home goods store, sells. Click a table name on the left to preview its rows, or the arrow next to it to see its columns.