select car, mpg, horsepower from cars_data order by displacement desc, car asc limit 3 ;
select car, mpg, horsepower from cars_data order by displacement desc, car asc limit 3 ;
SELECT car, mpg, horsepower FROM cars_data ORDER BY displacement DESC, car ASC LIMIT 3;
SELECT car, mpg, horsepower FROM cars_data ORDER BY displacement desc, car LIMIT 3;
SELECT car, mpg, horsepower FROM cars_data ORDER BY displacement desc, car LIMIT 3;
SELECT car, mpg, horsepower FROM cars_data ORDER BY displacement desc, car LIMIT 3;
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;
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;
select car, mpg, horsepower from cars_data order by displacement desc, car asc limit 3 ;