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;