See the whole table
Select some columns
Filtering rows
8. Conditional operators and selecting columns
Logic
Text patterns
To be or NULL to be
A little bit of mathematics
Let's practice

Instruction

You've got the hang of it already, haven't you? Let's combine what we know about conditional operators with selecting specific columns.

SELECT 
  id,
  age 
FROM user 
WHERE age <= 21;

Easy, right? Instead of the asterisk (*), we just name the specific columns we're interested in.

Exercise

Select brand, model and production year of all cars cheaper than or equal 10 000.

Stuck? Here's a hint!

Type:

SELECT
  brand, 
  model, 
  production_year 
FROM car 
WHERE price <= 10000;