Number filtering
But what if we want to choose a car with small mileage, let it be less than 5000 miles. We need to set the condition to a numeric column.
This also can be done with WHERE
statement. For example,
123SELECT * FROM audi_cars WHERE mileage < 5000
Comparison operators you also can use for numeric columns:
<
- less than<=
- less-equal>=
- greater-equal ->
- greater=
- equal<>
- not equal.
Now let's try to find the cheapest car in this dataset.
Swipe to start coding
From the audi_cars
dataset extract cars with price
less than 10 000.
Soluzione
Grazie per i tuoi commenti!
single
Chieda ad AI
Chieda ad AI
Chieda pure quello che desidera o provi una delle domande suggerite per iniziare la nostra conversazione
Riassuma questo capitolo
Explain code
Explain why doesn't solve task
Awesome!
Completion rate improved to 2.63
Number filtering
Scorri per mostrare il menu
But what if we want to choose a car with small mileage, let it be less than 5000 miles. We need to set the condition to a numeric column.
This also can be done with WHERE
statement. For example,
123SELECT * FROM audi_cars WHERE mileage < 5000
Comparison operators you also can use for numeric columns:
<
- less than<=
- less-equal>=
- greater-equal ->
- greater=
- equal<>
- not equal.
Now let's try to find the cheapest car in this dataset.
Swipe to start coding
From the audi_cars
dataset extract cars with price
less than 10 000.
Soluzione
Grazie per i tuoi commenti!
Awesome!
Completion rate improved to 2.63single