drop table if exists #tmp;

create table #tmp (id int identity (1, 1) primary key clustered, [data] xml);

insert into #tmp ([data])
  select try_cast([event_data] as xml) 
  from sys.fn_xe_file_target_read_file ( 'PATH', 'FILE', NULL, NULL);

create selective xml index ix on #tmp ([data])
for (
 p1 = '/event//data/value' as SQL INT SINGLETON,
 p2 = '/event//action/value' as SQL INT SINGLETON
);
     
with x as (
     select [data].value('(/event/data[@name="cpu_time"]/value)[1]', 'int') as [cpu_time],
            [data].value('(/event/action[@name="collect_cpu_cycle_time"]/value)[1]', 'int') as [cpu_cycle]
     from #tmp t
)
select sum([cpu_time]), sum([cpu_cycle])
from x;