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
Cambia al desktop per esercitarti nel mondo realeContinua da dove ti trovi utilizzando una delle opzioni seguentiGrazie 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
Awesome!
Completion rate improved to 2.63Awesome!
Completion rate improved to 2.63Number 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
Cambia al desktop per esercitarti nel mondo realeContinua da dove ti trovi utilizzando una delle opzioni seguentiGrazie per i tuoi commenti!
single
Awesome!
Completion rate improved to 2.63Number 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
Cambia al desktop per esercitarti nel mondo realeContinua da dove ti trovi utilizzando una delle opzioni seguentiGrazie per i tuoi commenti!
