Back

Answered by battlethechamp

select car, mpg, horsepower from 
cars_data
order by displacement desc, car asc

limit 3
;

Answered by vick0123

select car, mpg, horsepower from 
cars_data
order by displacement desc, car asc

limit 3
;

Answered by Waytan

SELECT car, mpg, horsepower
FROM cars_data
ORDER BY displacement DESC, car ASC
LIMIT 3;

Answered by gurneet kaur

SELECT car, mpg, horsepower FROM cars_data
ORDER BY displacement desc, car
LIMIT 3;

Answered by tymp

SELECT car, mpg, horsepower FROM cars_data
ORDER BY displacement desc, car
LIMIT 3;

Answered by wlldodsn

SELECT car, mpg, horsepower FROM cars_data
ORDER BY displacement desc, car
LIMIT 3;

Answered by trabi71

SELECT car, mpg, horsepower
FROM (
  SELECT car, mpg, horsepower
  FROM cars_data cd
  ORDER BY displacement DESC
  LIMIT 3
) AS top_disp
ORDER BY car asc;

Answered by superhoops540

SELECT car, mpg, horsepower
FROM (
  SELECT car, mpg, horsepower
  FROM cars_data cd
  ORDER BY displacement DESC
  LIMIT 3
) AS top_disp
ORDER BY car asc;

Answered by anonymousUser

select 
    car,
    mpg,
    horsepower
from cars_data
order by displacement desc, car asc
limit 3
;