Como solucionar problemas comuns de SQL com o BigQuery avaliações

Vishesh G. · Revisado há 2 months

박소현 G. · Revisado há 2 months

Esha G. · Revisado há 2 months

Łukasz J. · Revisado há 2 months

Haseeb I. · Revisado há 2 months

Haseeb I. · Revisado há 2 months

Anonymous Q. · Revisado há 2 months

Nio Z. · Revisado há 2 months

Seoyoon H. · Revisado há 2 months

Carolina D. · Revisado há 2 months

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. · Revisado há 2 months

Muhammadur R. · Revisado há 2 months

Hussan S. · Revisado há 2 months

WangWon K. · Revisado há 2 months

Surya T. · Revisado há 2 months

RAPOLU VIVEK K. · Revisado há 2 months

Darshan C. · Revisado há 2 months

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. · Revisado há 2 months

Un poco difícil ya para mi excelente aprendizaje

César D. · Revisado há 2 months

Pavan P. · Revisado há 2 months

Saumya B. · Revisado há 2 months

Ramakrishna N. · Revisado há 2 months

Montgomery S. · Revisado há 2 months

Shivakumar Y. · Revisado há 2 months

Isabel C. · Revisado há 2 months