Help SQL practice 9.2 Brand new car

Question

How do you sort company name by order?
SELECT company, year
FROM cars
WHERE year = 2020;
This is my coding for that practice question, but I’m not able to sort the company name by order.

Answer 1

ORDER by company;

Answer 2

I mean
SELECT company, year
FROM cars
WHERE year = 2020
ORDER by company;

Answer 3

Thanks guys i tried both of your coding and it works

Answer 4

SELECT company, year
FROM cars
WHERE year = 2020
ORDER BY company ASC;
Try again this. It must be work. Adam Ali

Answer 5

Hi

Answer 6

Add this line,
ORDER BY company ASC;
to order the company names by ascend.
I hope, it helps. Happy coding!

Answer 7

I tried both of your code -
SELECT company, year
FROM cars
ORDER BY company
WHERE year = 2020;
And ORDER BY company ASC
It still doesnt work.

Answer 8

SELECT COMPANY,YEAR
FROM CARS WHERE YEAR = 2020 ORDER BY COMPANY;