Troubleshooting Common SQL Errors with BigQuery Reviews

Very confusing lab. Some things I can troubleshoot by sight, yet I have to run the code in order to progress in the lab. Two other things: 1) One of the questions had the answer of, "The page title is missing from the columns in SELECT". I don't know what that means. I don't believe there was anything in the material about page titles and I've never seen this in my years of working with SQL. 2) Another answer referred to using legacy SQL. Here's the code: #standardSQL SELECT * FROM [data-to-insights:ecommerce.rev_transactions] LIMIT 1000 How am I supposed to know that is legacy SQL? I'm used to working in SSMS and I've never seen any query using that syntax.

Clinton H. · Reviewed almost 2 years ago

not very clear instructions

Tulio R. · Reviewed almost 2 years ago

Aimee J. · Reviewed almost 2 years ago

Tamara M. · Reviewed almost 2 years ago

Rong L. · Reviewed almost 2 years ago

Lucas H. · Reviewed almost 2 years ago

Juan M. · Reviewed almost 2 years ago

Shyam Kumar S. · Reviewed almost 2 years ago

Elena P. · Reviewed almost 2 years ago

Ujjal P. · Reviewed almost 2 years ago

David V. · Reviewed almost 2 years ago

Alan R. · Reviewed almost 2 years ago

Mohamed A. · Reviewed almost 2 years ago

Anjali S. · Reviewed almost 2 years ago

Ankit G. · Reviewed almost 2 years ago

Krati V. · Reviewed almost 2 years ago

Darshit S. · Reviewed almost 2 years ago

Shubham U. · Reviewed almost 2 years ago

Soumya B. · Reviewed almost 2 years ago

Jean C. · Reviewed almost 2 years ago

Sérgio B. · Reviewed almost 2 years ago

Joselia O. · Reviewed almost 2 years ago

Rafael G. · Reviewed almost 2 years ago

Gabriel A. · Reviewed almost 2 years ago

Robson F. · Reviewed almost 2 years ago