Contenido del Curso
SQL Basics
SQL Basics
6. Practicing
Challenge: Unique combinationsChallenge: Average Q-series cars priceChallenge: The cheapest new A-series carsChallenge: Relation between engine size and fuel consumptionChallenge: Mileage and manufacture year - is there relation?Challenge: Average price for each model and yearChallenge: The most expensive transmission + engine size combinations
Least consuming cars
Let's find out the least consuming cars in terms of model and fuel type.
Tarea
Swipe to start coding
From the audi_cars
dataset extract model
and fueltype
columns and order by average fuel consuming (mpg
) in ascending order.
Solución
¿Todo estuvo claro?
¡Gracias por tus comentarios!
Sección 5. Capítulo 6
Least consuming cars
Let's find out the least consuming cars in terms of model and fuel type.
Tarea
Swipe to start coding
From the audi_cars
dataset extract model
and fueltype
columns and order by average fuel consuming (mpg
) in ascending order.
Solución
¿Todo estuvo claro?
¡Gracias por tus comentarios!
Sección 5. Capítulo 6