Working with JSON, Arrays, and Structs in BigQuery Reviews

There was a typo in one of the bullet points in the STRUCTS section where it says "It's own alias" but since it is being used as a possessive pronoun, there should not be a comma and the correct typing would be "Its own alias". Also, the control+F nor the schema filters were working to find the correct count of structs or arrays in the schema within the lab. Not sure if this was an incognito window issue, something do do with the way Chrome loads the data in the page on a MacBook or something else. Either way, I couldn't seem to find the right numbers without guessing. Even my manual scrolling and counting didn't seem to match what the lab questions expected. And one of the last questions/challenges involved finding the racer with a 23.2 split_time. The solution required me to use UNNEST() but it worked without this. Gemini says that's because the comma implicitly UNNESTS but I don't recall seeing that explanation in the lab. I remember seeing that on implicitly cross joining, but not for unnesting.

Andrew F. · Reviewed בערך 11 שעות ago

Biswanath P. · Reviewed בערך 12 שעות ago

Diptesh C. · Reviewed בערך 14 שעות ago

Umair A. · Reviewed בערך 16 שעות ago

Eitaro T. · Reviewed בערך 17 שעות ago

Anjali K. · Reviewed בערך 17 שעות ago

Cloud Storage バケットがなく、ファイルを参照できないためファイル構造を指定できなかったため、進行できないで終了した

秀人 Hideto Shibao 芝. · Reviewed בערך 21 שעות ago

Marko P. · Reviewed יום אחד ago

Martina C. · Reviewed יום אחד ago

Ronald Alejandro R. · Reviewed יום אחד ago

poornima S. · Reviewed יום אחד ago

Chakka Chenna J. · Reviewed יום אחד ago

Abdul Mazeed S. · Reviewed 2 ימים ago

Kaori S. · Reviewed 2 ימים ago

Aline A. · Reviewed 2 ימים ago

Dmitrii D. · Reviewed 2 ימים ago

Swastika M. · Reviewed 3 ימים ago

Devendra V. · Reviewed 3 ימים ago

Peng T. · Reviewed 3 ימים ago

david b. · Reviewed 3 ימים ago

Barbara M. · Reviewed 3 ימים ago

Kush Bhargav S. · Reviewed 3 ימים ago

Juliana C. · Reviewed 3 ימים ago

Ninoska E. · Reviewed 3 ימים ago

Beini W. · Reviewed 3 ימים ago