Ultimate access to all questions.
Upgrade Now 🚀
Sign in to unlock AI tutor
As a data engineer, you're tasked with querying data from an e-commerce website's events table, which includes a geo field of struct type containing a country subfield. How would you correctly query the data based on the country subfield?
A
SELECT geo:country FROM events WHERE geo:country = ‘India‘
B
SELECT geo.country FROM events WHERE geo.country = ‘India‘
C
SELECT country FROM events WHERE country = ‘India‘
D
E
SELECT struct.country FROM events WHERE struct.country = ‘India‘
F
SELECT geocountry FROM events WHERE geocountry = ‘India‘
