HAVING some conditions
What if we want to filter grouped observations based on some condition? For example, we want to extract only those models available with Hybrid fuel types.
You can do it by grouping firstly by model, and then by fuel type filtered by condition on fueltype
.
1234SELECT model FROM audi_cars GROUP BY model, fueltype HAVING fueltype = 'Hybrid'
Please note, that you can use all the operators learned in the second section within
HAVING
statement.
Swipe to start coding
From the audi_cars
table extract all the models available with Automatic transmission
.
Solución
¡Gracias por tus comentarios!
single
Pregunte a AI
Pregunte a AI
Pregunte lo que quiera o pruebe una de las preguntas sugeridas para comenzar nuestra charla
Resumir este capítulo
Explicar el código en file
Explicar por qué file no resuelve la tarea
Awesome!
Completion rate improved to 2.63
HAVING some conditions
Desliza para mostrar el menú
What if we want to filter grouped observations based on some condition? For example, we want to extract only those models available with Hybrid fuel types.
You can do it by grouping firstly by model, and then by fuel type filtered by condition on fueltype
.
1234SELECT model FROM audi_cars GROUP BY model, fueltype HAVING fueltype = 'Hybrid'
Please note, that you can use all the operators learned in the second section within
HAVING
statement.
Swipe to start coding
From the audi_cars
table extract all the models available with Automatic transmission
.
Solución
¡Gracias por tus comentarios!
Awesome!
Completion rate improved to 2.63single