Order by SQL line

How would I go about creating an SQL line that puts each car from new to old (Years) but also keeps it in alphabetical order

For example it needs to do this

2018 Acura Model X
2018 Acura Model X
2017 Acura Model X
2017 Acura Model X
2018 Audi Model X
2017 Audi Model X
2018 BMW Model X

This is how its displaying

MY View

Answer

You may try the following query:

SELECT *
FROM yourTable
ORDER BY
    SUBSTRING_INDEX(SUBSTR(name, 6), ' ', 1),   -- order ascending by model name
    LEFT(name, 4) DESC;                         -- order descending by model year

The call I make to SUBSTRING_INDEX extracts the second word from the model string. This is assumed to be the model name.

Demo