Notice: This page requires JavaScript to function properly.
Please enable JavaScript in your browser settings or update your browser.
Apprendre Challenge: Relation between engine size and fuel consumption | Practicing
SQL Basics

bookChallenge: Relation between engine size and fuel consumption

Tâche

Swipe to start coding

From the audi_cars table calculate the average fuel consumption (mpg column) for each engine size (enginesize). Order results in descending order by the average value of mpg. Expected output: enginesize | average mpg.

Solution

The result may seem strange, but don't forget that the mpg column refers to miles per gallon. The greater this value, the less fuel car consumes.

Tout était clair ?

Comment pouvons-nous l'améliorer ?

Merci pour vos commentaires !

Section 6. Chapitre 4
single

single

Demandez à l'IA

expand

Demandez à l'IA

ChatGPT

Posez n'importe quelle question ou essayez l'une des questions suggérées pour commencer notre discussion

Suggested prompts:

Résumer ce chapitre

Expliquer le code dans file

Expliquer pourquoi file ne résout pas la tâche

close

Awesome!

Completion rate improved to 2.63

bookChallenge: Relation between engine size and fuel consumption

Glissez pour afficher le menu

Tâche

Swipe to start coding

From the audi_cars table calculate the average fuel consumption (mpg column) for each engine size (enginesize). Order results in descending order by the average value of mpg. Expected output: enginesize | average mpg.

Solution

The result may seem strange, but don't forget that the mpg column refers to miles per gallon. The greater this value, the less fuel car consumes.

Switch to desktopPassez à un bureau pour une pratique réelleContinuez d'où vous êtes en utilisant l'une des options ci-dessous
Tout était clair ?

Comment pouvons-nous l'améliorer ?

Merci pour vos commentaires !

close

Awesome!

Completion rate improved to 2.63
Section 6. Chapitre 4
single

single

some-alt