Вивчайте 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.


              1234
            
SELECT 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.

Рішення

Перейдіть на комп'ютер для реальної практикиПродовжуйте з того місця, де ви зупинились, використовуючи один з наведених нижче варіантів

Все було зрозуміло?

Дякуємо за ваш відгук!

Секція 5. Розділ 5

single

Запитати АІ

Запитайте про що завгодно або спробуйте одне із запропонованих запитань, щоб почати наш чат

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'

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.

Рішення

Все було зрозуміло?

Дякуємо за ваш відгук!

Секція 5. Розділ 5

single

Свайпніть щоб показати меню

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'

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.

Рішення

Все було зрозуміло?

Дякуємо за ваш відгук!

HAVING some conditions

Рішення

Awesome!

HAVING some conditions

Рішення

Awesome!

HAVING some conditions

Рішення