Edfora interview question

SQL queries Flattening Nested Array