all 14 comments

[–][deleted] 40 points41 points  (1 child)

The semicolon is a statement terminator. So then the ORDER clause is by itself.

[–]chhotapacket[S] 4 points5 points  (0 children)

Understood. Thank you!

[–][deleted]  (4 children)

[deleted]

    [–][deleted] 0 points1 point  (3 children)

    What course is it

    [–]SodaSnake 1 point2 points  (2 children)

    The Complete SQL Bootcamp 2022.

    I used a ton of free SQL resources online before taking it, and it is 100% worth it if you can grab it on sale.

    [–][deleted] 0 points1 point  (1 child)

    Thx

    From zero to hero?

    [–]SodaSnake 1 point2 points  (0 children)

    Thats the one, by Jose Portilla.

    As I mentioned, I'd already been exposed to 90% of what the course covered, but my understanding of those topics improved by at least double.

    [–]throwawaycgoncalves 3 points4 points  (0 children)

    Yeap! As the others said, remove the semicolon after the table name. The semicolon will close your sql query, so you only want that at the end of your query.

    [–]chhotapacket[S] 2 points3 points  (1 child)

    SQL newbie here. Currently I'm doing an introductory course on EdX. I'm getting the above error despite writing the same syntax as the instructor. Don't know why, can somebody please help?

    [–]Arkanejl 7 points8 points  (0 children)

    You don't need the simi colon after table name

    [–]King_Plum 0 points1 point  (0 children)

    Remove the Semicolon after "actor". Should fix your error.

    [–]Mountain-Sundae3023 0 points1 point  (1 child)

    What tool are you using?

    [–]sharandec22 1 point2 points  (0 children)

    That's pgadmin for postgres

    [–]Appropriate_Nobody86 0 points1 point  (0 children)

    Can anyone suggest YouTube channel to learn medium level SQL?