
Ultimate access to all questions.
You are working with a table in BigQuery that contains a nested column named 'city' within a column named 'person'. However, when you attempt to run the query SELECT person FROM 'project1.example.table1' WHERE city = 'London', an error occurs. What is the correct way to fix this error?
A
Change 'person' to 'city.person'.
B
Add ', UNNEST(city)' before the WHERE clause.
C
Add ', UNNEST(person)' before the WHERE clause.
D
Change 'person' to 'person.city'.