Working with JSON, Arrays, and Structs in BigQuery Reviews

D23DCE148 H. · Reviewed yaklaşık 2 yıl ago

Tarun S. · Reviewed yaklaşık 2 yıl ago

Vaishnavi S. · Reviewed yaklaşık 2 yıl ago

Good lab

Fenil P. · Reviewed yaklaşık 2 yıl ago

Yash S. · Reviewed yaklaşık 2 yıl ago

Viren R. · Reviewed yaklaşık 2 yıl ago

Good

Dipak D. · Reviewed yaklaşık 2 yıl ago

Mona G. · Reviewed yaklaşık 2 yıl ago

Good

Rupak D. · Reviewed yaklaşık 2 yıl ago

nice

Vishal G. · Reviewed yaklaşık 2 yıl ago

Dadang Y. · Reviewed yaklaşık 2 yıl ago

ali s. · Reviewed yaklaşık 2 yıl ago

PAJJURU K. · Reviewed yaklaşık 2 yıl ago

GREAT

Aswin P. · Reviewed yaklaşık 2 yıl ago

Ayush G. · Reviewed yaklaşık 2 yıl ago

Porje P. · Reviewed yaklaşık 2 yıl ago

Ashley P. · Reviewed yaklaşık 2 yıl ago

Muhamad Arwin W. · Reviewed yaklaşık 2 yıl ago

farian h. · Reviewed yaklaşık 2 yıl ago

Moses M. · Reviewed yaklaşık 2 yıl ago

Doug C. · Reviewed yaklaşık 2 yıl ago

great lab

Abhishek T. · Reviewed yaklaşık 2 yıl ago

Surojit D. · Reviewed yaklaşık 2 yıl ago

moussa n. · Reviewed yaklaşık 2 yıl ago

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. · Reviewed yaklaşık 2 yıl ago