You are trying to calculate total sales databricks video

Full Certification Question

You are trying to calculate total sales made by all the 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 } ] Calculate total sales made by all the employees? Sample data with create table syntax for the data: create or replace table sales as select 1 as batchId , from_json ( '[{ "employeeId":1234,"sales" : 10000 },{ "employeeId":3232,"sales" : 30000 }]' , 'ARRAY>' ) as performance , current_timestamp () as insertDate union all select 2 as batchId , from_json ( '[{ "employeeId":1235,"sales" : 10500 },{ "employeeId":3233,"sales" : 32000 }]' , 'ARRAY>' ) as performance , current_timestamp () as insertDate