Syntax error: Unexpected keyword WHERE at [5:1], Syntax error: Unexpected keyword WHERE at [4:1]

I enrolled for Google Data Analytics and started learning Google Query. In my queries, I keep having syntax error even after copying from the instruction page to my console. I have been stuck here for 3 days now and i need your help.

See attached images for more illustration.

Howdy … you have a β€œ;” following the table name on line 4. The β€œ;” character ends one statement and starts a completely new statement. Your WHERE clause is still part of the original query. The SQL parser saw the end of the first query and said β€œHmmm … here is a new statement that reads β€˜WHERE’” and that fully explains the message. Remove the β€œ;” and you should be well.

5 Likes

I’ve also been stuck in this same area for thr program. Thank you so much for the comment! It helped keep me from pulling my hair out.

1 Like

Thank you, Kolban, for your assistance. I truly appreciate your answer. I had been struggling with the same problem, but following your guidance has provided a great sense of relief.

I was stuck here too! So frustrating, thanks a ton for the solution

thank you so much!

Thanks Colban!!