Notice: This page requires JavaScript to function properly.
Please enable JavaScript in your browser settings or update your browser.Learn HAVING some conditions | Grouping
SQL Basics

bookHAVING 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.


              
1234

            
SELECT model
FROM audi_cars
GROUP BY model, fueltype
HAVING fueltype = 'Hybrid'
copy

Please note, that you can use all the operators learned in the second section within HAVING statement.

Task

Swipe to start coding

From the audi_cars table extract all the models available with Automatic transmission.

Solution

Switch to desktopSwitch to desktop for real-world practiceContinue from where you are using one of the options below
Everything was clear?

How can we improve it?

Thanks for your feedback!

SectionΒ 5. ChapterΒ 5
single

single

Ask AI

expand

Ask AI

ChatGPT

Ask anything or try one of the suggested questions to begin our chat

close

Awesome!

Completion rate improved to 2.63

bookHAVING 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.


              
1234

            
SELECT model
FROM audi_cars
GROUP BY model, fueltype
HAVING fueltype = 'Hybrid'
copy

Please note, that you can use all the operators learned in the second section within HAVING statement.

Task

Swipe to start coding

From the audi_cars table extract all the models available with Automatic transmission.

Solution

Switch to desktopSwitch to desktop for real-world practiceContinue from where you are using one of the options below
Everything was clear?

How can we improve it?

Thanks for your feedback!

SectionΒ 5. ChapterΒ 5
single

single

close

Awesome!

Completion rate improved to 2.63

bookHAVING some conditions

Swipe to show menu

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.


              
1234

            
SELECT model
FROM audi_cars
GROUP BY model, fueltype
HAVING fueltype = 'Hybrid'
copy

Please note, that you can use all the operators learned in the second section within HAVING statement.

Task

Swipe to start coding

From the audi_cars table extract all the models available with Automatic transmission.

Solution

Switch to desktopSwitch to desktop for real-world practiceContinue from where you are using one of the options below
Everything was clear?

How can we improve it?

Thanks for your feedback!

some-alt