Conteúdo do Curso
SQL Basics
SQL Basics
Challenge: Relation between engine size and fuel consumption
Tarefa
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.
Tarefa
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.
The result may seem strange, but don't forget that the
mpgcolumn refers to miles per gallon. The greater this value, the less fuel car consumes.
Mude para o desktop para praticar no mundo realContinue de onde você está usando uma das opções abaixoTudo estava claro?
Challenge: Relation between engine size and fuel consumption
Tarefa
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.
Tarefa
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.
The result may seem strange, but don't forget that the
mpgcolumn refers to miles per gallon. The greater this value, the less fuel car consumes.
Mude para o desktop para praticar no mundo realContinue de onde você está usando uma das opções abaixoTudo estava claro?
Challenge: Relation between engine size and fuel consumption
Tarefa
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.
Tarefa
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.
The result may seem strange, but don't forget that the
mpgcolumn refers to miles per gallon. The greater this value, the less fuel car consumes.
Mude para o desktop para praticar no mundo realContinue de onde você está usando uma das opções abaixoTudo estava claro?
Tarefa
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.
The result may seem strange, but don't forget that the
mpgcolumn refers to miles per gallon. The greater this value, the less fuel car consumes.
Mude para o desktop para praticar no mundo realContinue de onde você está usando uma das opções abaixoMude para o desktop para praticar no mundo realContinue de onde você está usando uma das opções abaixo