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
HAVINGstatement.
Swipe to start coding
From the audi_cars table extract all the models available with Automatic transmission.
Lösung
Wechseln Sie zum Desktop, um in der realen Welt zu übenFahren Sie dort fort, wo Sie sind, indem Sie eine der folgenden Optionen verwendenDanke für Ihr Feedback!
single
Fragen Sie AI
Fragen Sie AI
Fragen Sie alles oder probieren Sie eine der vorgeschlagenen Fragen, um unser Gespräch zu beginnen
Awesome!
Completion rate improved to 2.63Awesome!
Completion rate improved to 2.63HAVING 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
HAVINGstatement.
Swipe to start coding
From the audi_cars table extract all the models available with Automatic transmission.
Lösung
Wechseln Sie zum Desktop, um in der realen Welt zu übenFahren Sie dort fort, wo Sie sind, indem Sie eine der folgenden Optionen verwendenDanke für Ihr Feedback!
single
Awesome!
Completion rate improved to 2.63HAVING some conditions
Swipe um das Menü anzuzeigen
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
HAVINGstatement.
Swipe to start coding
From the audi_cars table extract all the models available with Automatic transmission.
Lösung
Wechseln Sie zum Desktop, um in der realen Welt zu übenFahren Sie dort fort, wo Sie sind, indem Sie eine der folgenden Optionen verwendenDanke für Ihr Feedback!
