Edfora Interview Question

SQL queries Flattening Nested Array