Troubleshooting Common SQL Errors with BigQuery Reviews

Vishesh G. · Reviewed شهران ago

박소현 G. · Reviewed شهران ago

Esha G. · Reviewed شهران ago

Łukasz J. · Reviewed شهران ago

Haseeb I. · Reviewed شهران ago

Haseeb I. · Reviewed شهران ago

Anonymous Q. · Reviewed شهران ago

Nio Z. · Reviewed شهران ago

Seoyoon H. · Reviewed شهران ago

Carolina D. · Reviewed شهران ago

In the question: #standardSQL SELECT fullVisitorId FROM `data-to-insights.ecommerce.rev_transactions` What is wrong with the previous query? [ ] We are missing a column alias [ ] Without aggregations, limits, or sorting, this query is not insightful [ ] The page title is missing from the columns in SELECT [ ] We are missing a LIMIT clause There are two correct answers ( (i) Without aggregations, limits, or sorting, this query is not insightful; (ii) The page title is missing from the columns in SELECT), but there is also no alias. So the answers remain dubious. Is there a title missing but an alias exists?

Cleônidas T. · Reviewed شهران ago

Muhammadur R. · Reviewed شهران ago

Hussan S. · Reviewed شهران ago

WangWon K. · Reviewed شهران ago

Surya T. · Reviewed شهران ago

RAPOLU VIVEK K. · Reviewed شهران ago

Darshan C. · Reviewed شهران ago

It would be an improvement to be able to make modifications to the queries, even different from the proposed ones, without affecting the progress check.

Pablo Ignacio D. · Reviewed شهران ago

Un poco difícil ya para mi excelente aprendizaje

César D. · Reviewed شهران ago

Pavan P. · Reviewed شهران ago

Saumya B. · Reviewed شهران ago

Ramakrishna N. · Reviewed شهران ago

Montgomery S. · Reviewed شهران ago

Shivakumar Y. · Reviewed شهران ago

Isabel C. · Reviewed شهران ago