Please , can someone point out my mistake ? It's an SQL task.

Question

I'm working on an SQL task which asks me to sort cars by model year.

My code :

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

When i run it , the app says this :

"ERRO: syntax error at or near "WHERE"
LINE 4: WHERE year = 2020;
^
"

Any ideas ? As always , i greatly appreciate this community ! :).

Answer 1

Try to place filter specification first (WHERE), then followed by sorting specification (ORDER BY).

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

Answer 2

Well, that's odd, let's see what others has to say ...

Did the task specify to filter cars built around 2020? (WHERE year = 2020)? maybe it can be removed.

BTW, your Description said "to sort cars by model year" I think the ORDER BY should use 'year' rather than 'company'.

Answer 3

Well, I don't know either.
But if that solves the case then it's good news! 👍

Answer 4

Apparently the Description in the original post above was different with the most recent one you shared.

I'm sorry my suggestion didn't work out, but I'm pretty sure someone more knowledgeable can assist you to get through 👍

Answer 5

Ipang

Indeed ! :).

Answer 6

Ipang

Thank you for the suggestion , but the only thing that changed is that the ERROR message now says the same thing , but with ORDER BY instead pf WHERE.

Answer 7

@Ipang

This is the description :

The WHERE Statement

"You are given the following table of cars with details

:contentImage

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

Use the WHERE statement!"

I've used your suggestion of changing the ORDER BY , but it only changed the ERROR message to the first one i got. Thank you for this suggestion nonetheless ! :).

Answer 8

Ipang

Oh , sorry. Thank you for your time & have a great day with fantastic luck , wherever & whenever you are ! :). 👍

Answer 9

Ipang

Hey , Ipang ! After some Googling , i found this code from one

@Såñtösh

Here it is :

select company ,year from cars where year=2020 order by company;

I don't know how , but it worked.

Answer 10

try this and it will resolve the problem. thanks for understanding

select company, year
from cars
where year=2020
order by company Asc;

Answer 11

To type the order by is after where condition

Answer 12

FREDERIC DANIMBE

Hi , Frederic ! I have solved this issue long ago , but thank you for your help nonetheless ! Have a great day & fantastic luck ! :).

Answer 13

U should put 'order by' after 'where' condition

Answer 14

select * from cars where engine ='electric' or year > 2018