Sql 9.2practice answer

Question

select company, year from cars where year =2020 ;

How can i make this to descending order?

Answer 1

You can try this i hope it solve your problem

SELECT company, year
FROM cars
WHERE year = 2020
ORDER BY year DESC;

Answer 2

Its great to be focused on the lessons but you should always find another ways to learn such as Google, Youtube etc. I am also a beginner but I passed so quickly.

Answer 3

SELECT company, year FROM cars WHERE year = 2020 ORDER BY year DESC;

Answer 4

You can try this

SELECT company, year
FROM cars
WHERE year = 2020
ORDER BY year DESC;

The year is DESC

Answer 5

ORDER BY company ASC ;