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
;