Como trabalhar com dados dos tipos JSON, matriz e struct no BigQuery avaliações

D23DCE148 H. · Revisado há about 2 years

Tarun S. · Revisado há about 2 years

Vaishnavi S. · Revisado há about 2 years

Good lab

Fenil P. · Revisado há about 2 years

Yash S. · Revisado há about 2 years

Viren R. · Revisado há about 2 years

Good

Dipak D. · Revisado há about 2 years

Mona G. · Revisado há about 2 years

Good

Rupak D. · Revisado há about 2 years

nice

Vishal G. · Revisado há about 2 years

Dadang Y. · Revisado há about 2 years

ali s. · Revisado há about 2 years

PAJJURU K. · Revisado há about 2 years

GREAT

Aswin P. · Revisado há about 2 years

Ayush G. · Revisado há about 2 years

Porje P. · Revisado há about 2 years

Ashley P. · Revisado há about 2 years

Muhamad Arwin W. · Revisado há about 2 years

farian h. · Revisado há about 2 years

Moses M. · Revisado há about 2 years

Doug C. · Revisado há about 2 years

great lab

Abhishek T. · Revisado há about 2 years

Surojit D. · Revisado há about 2 years

moussa n. · Revisado há about 2 years

Good!! Another approach to task 9: #standardSQL SELECT p.name, split_time FROM racing.race_results AS r, unnest(r.participants) AS p, unnest(p.splits) AS split_time --WHERE split_time = 23.2; --need to know the value beforehand ORDER BY split_time ASC --does not need to know value beforehand LIMIT 1 --limit by 3 gives the values of gold, silver and bronze medals

Lucas Z. · Revisado há about 2 years