data-engineer-associate video for you are trying to calculate the total sales made by all employees by parsing a complex struct data type that stores employee
You are trying to calculate the total sales made by all employees by parsing a complex struct data type that stores employee and sales data. How would you approach this in SQL? **Table definition:** batchId INT, performance ARRAY, insertDate TIMESTAMP **Sample data of performance column:** [ { "employeeId":1234, "sales": 10000}, { "employeeId":3232, "sales": 30000} ] **SQL query options to calculate total sales:**