Working with JSON, Arrays, and Structs in BigQuery Reviews

nice

Ashmit S. · Reviewed בערך 2 חודשים ago

Rohan G. · Reviewed בערך 2 חודשים ago

Yash G. · Reviewed בערך 2 חודשים ago

Nice

Arghya B. · Reviewed בערך 2 חודשים ago

Siyad A. · Reviewed בערך 2 חודשים ago

Azmat S. · Reviewed בערך 2 חודשים ago

Shantanu S. · Reviewed בערך 2 חודשים ago

Dwayne G. · Reviewed בערך 2 חודשים ago

Ayush J. · Reviewed בערך 2 חודשים ago

sidda G. · Reviewed בערך 2 חודשים ago

Artem L. · Reviewed בערך 2 חודשים ago

PALASH D. · Reviewed בערך 2 חודשים ago

Palash D. · Reviewed בערך 2 חודשים ago

Pardha K. · Reviewed בערך 2 חודשים ago

Quique A. · Reviewed בערך 2 חודשים ago

nice

Argha D. · Reviewed בערך 2 חודשים ago

Amol T. · Reviewed בערך 2 חודשים ago

very good

Safalta K. · Reviewed בערך 2 חודשים ago

It's a little unclear why the UNNEST() is necessary in correlated cross join. When I ran the queries in the last couple of steps without UNNESTING (simply filtering, grouping and ordering, I still got the correct answer. Similarly, I did UNNEST on step 7 where Cross JOIN was introduced and got the correct answer. It's a strong lab, I think I'd just like to see more about some of the nuanced differences between UNNESTing and CROSS JOINING

Anthony C. · Reviewed בערך 2 חודשים ago

Manshi R. · Reviewed בערך 2 חודשים ago

Rajesh R. · Reviewed בערך 2 חודשים ago

Ribca N. · Reviewed בערך 2 חודשים ago

Nirmala J. · Reviewed בערך 2 חודשים ago

Srinivasulu J. · Reviewed בערך 2 חודשים ago

JVS T. · Reviewed בערך 2 חודשים ago