Working with JSON, Arrays, and Structs in BigQuery avis

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. · Examiné il y a 5 heures

Biswanath P. · Examiné il y a 6 heures

Diptesh C. · Examiné il y a 8 heures

Umair A. · Examiné il y a 10 heures

Eitaro T. · Examiné il y a 11 heures

Anjali K. · Examiné il y a 11 heures

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

秀人 Hideto Shibao 芝. · Examiné il y a 15 heures

Marko P. · Examiné il y a 23 heures

Martina C. · Examiné il y a 24 heures

Ronald Alejandro R. · Examiné il y a 1 jour

poornima S. · Examiné il y a 1 jour

Chakka Chenna J. · Examiné il y a 1 jour

Abdul Mazeed S. · Examiné il y a 1 jour

Kaori S. · Examiné il y a 1 jour

Aline A. · Examiné il y a 2 jours

Dmitrii D. · Examiné il y a 2 jours

Swastika M. · Examiné il y a 2 jours

Devendra V. · Examiné il y a 2 jours

Peng T. · Examiné il y a 3 jours

david b. · Examiné il y a 3 jours

Barbara M. · Examiné il y a 3 jours

Kush Bhargav S. · Examiné il y a 3 jours

Juliana C. · Examiné il y a 3 jours

Ninoska E. · Examiné il y a 3 jours

Beini W. · Examiné il y a 3 jours