Get hands-on experience with 20+ free Google Cloud products and $300 in free credit for new customers.

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

Hya213
New Member

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.

Screenshot 2024-03-09 10.58.02 AM.png

Screenshot 2024-03-09 10.57.34 AM.png

0 6 2,421
6 REPLIES 6

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.

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.

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.

thank you so much!

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

Thanks Colban!!