0

SQL 9.2 Practice answer

What is the right code for the SQL 9.2 practice. I thought it would be: SELECT company, year FROM cars ORDER BY company WHERE year = 2020; But it still says there is a mistake at or near WHERE. But it runs without ORDER BY so the mistake must be there, but I can't seem to identify it.

5th Aug 2021, 8:06 PM
Innil
Innil - avatar
1 Resposta
+ 1
SELECT company, year FROM cars WHERE year = 2020 ORDER BY company; This worked, thank you!
5th Aug 2021, 8:14 PM
Innil
Innil - avatar