Explore flat and nested data types in BigQuery Reviews

This query SELECT event_date, event_name, geo.country, items FROM `thelook_gcda.ga4_events` WHERE event_name = 'view_item' and geo.country = 'Singapore'; returns 12 item rows not 9 it appears. I got the right answer by leaving it blank then finiding it later on.

Bill S. · Reviewed 16 days ago

SOHAN S. · Reviewed 16 days ago

NAVEEN KUMAR T. · Reviewed 16 days ago

Muskan P. · Reviewed 16 days ago

238R1A67G2 K. · Reviewed 16 days ago

good

GUBENTHIRAN S G. · Reviewed 16 days ago

Luis R. · Reviewed 16 days ago

David B. · Reviewed 16 days ago

Samantha T. · Reviewed 16 days ago

dasari m. · Reviewed 17 days ago

Alure R. · Reviewed 17 days ago

Rishi B. · Reviewed 17 days ago

Avula K. · Reviewed 17 days ago

Kachepalli B. · Reviewed 17 days ago

Hanna M. · Reviewed 17 days ago

Mohsin K. · Reviewed 17 days ago

Upputuri M. · Reviewed 17 days ago

Fabrice L. · Reviewed 17 days ago

not bad

Rahul B. · Reviewed 17 days ago

YAGNESH K. · Reviewed 17 days ago

Abhishek D. · Reviewed 17 days ago

Instructions should be in rookie style

Eliabu L. · Reviewed 17 days ago

Sharvesh B. · Reviewed 17 days ago

BHARATHI R. · Reviewed 17 days ago

DEEPAN S. · Reviewed 17 days ago