Back

Answered by Waytan

select round(avg(mpg),2) as avg_mpg, cylinders
from cars_data
group by cylinders
order by avg(mpg) desc
;

Answered by gurneet kaur

select round(avg(mpg),2) as avg_mpg, cylinders
from cars_data
group by cylinders
order by avg(mpg) desc
;

Answered by Pfwd44

select round(avg(mpg),2) as avg_mpg, cylinders
from cars_data
group by cylinders
order by avg(mpg) desc
;

Answered by MGjuraj

select round(avg(mpg), 2) as avg_mpg, cylinders
from cars_data group by cylinders order by avg_mpg desc;

Answered by tymp

select round(avg(mpg),2) as avg_mpg, cylinders from cars_data group by cylinders
order by avg_mpg desc;

Answered by ran428

select round(avg(mpg),2) as avg_mpg, cylinders from cars_data group by cylinders
order by avg_mpg desc;

Answered by trabi71

select round(avg(mpg),2) as avg_mpg, cylinders from cars_data group by cylinders
order by avg_mpg desc;

Answered by sbalema2

select round(avg(mpg),2) as avg_mpg, cylinders from cars_data group by cylinders
order by avg_mpg desc;

Answered by superhoops540

SELECT ROUND(AVG(mpg), 2) AS avg_mpg, cylinders
FROM cars_data cd
GROUP BY cylinders
ORDER BY AVG(mpg) DESC;

Answered by sbw0125

select  Round(avg(mpg),2) as avg_mpg, cylinders
from cars_data
group by 2
order by 1 desc;

Answered by salemnye

select  Round(avg(mpg),2) as avg_mpg, cylinders
from cars_data
group by 2
order by 1 desc;

Answered by jrz1977

select  Round(avg(mpg),2) as avg_mpg, cylinders
from cars_data
group by 2
order by 1 desc;

Answered by anonymousUser

select  Round(avg(mpg),2) as avg_mpg, cylinders
from cars_data
group by 2
order by 1 desc;

Answered by parth

select  Round(avg(mpg),2) as avg_mpg, cylinders
from cars_data
group by 2
order by 1 desc;