How to fix the "Cannot output multiple independently repeated fields at the same time" error?

To query nested data (the fields with the RECORD data type), use the FLATTEN function.

Please read BigQuery reference guide for more information.