Notice: This page requires JavaScript to function properly.
Please enable JavaScript in your browser settings or update your browser.
Aprenda Least consuming cars | Grouping
SQL Basics

book
Least consuming cars

Let's find out the least consuming cars in terms of model and fuel type.

Tarefa

Swipe to start coding

From the audi_cars dataset extract model and fueltype columns and order by average fuel consuming (mpg) in ascending order.

Solução

SELECT model, fueltype
FROM audi_cars
GROUP BY model, fueltype
ORDER BY AVG(mpg)

Tudo estava claro?

Como podemos melhorá-lo?

Obrigado pelo seu feedback!

Seção 5. Capítulo 6

toggle bottom row
Query ResultQuery Result
No query executed yet...
We use cookies to make your experience better!
some-alt