The WHERE Statement

Question

Brand New Cars

You are given the following table of cars with details:

Write a query to output the brand and model years of the cars produced in 2020, sorted by the 'company' column.

My code as below:

SELECT company, year
FROM cars
WHERE year = '2020';

But the result that comes out say “no input”.

Please help.

Answer 1

you miss at least the sort requirement ^^

Answer 2

Got it. Thanks visph for the hint. Need to use ORDER BY.

Answer 3

You can try this also,

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

Answer 4

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

Answer 5

SELECT * FROM cars
WHERE year=2018 OR year>=2018;

Answer 6

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

I tested it
Should work