blob: d290d2ae6bcd2792253419f8f37948a2e3f183cd [file] [log] [blame]
select uid, MAX(l1+l2) from (select uid,flatten(lst_lst[1]) l1, flatten(lst_lst[0]) l2 from `data.json`) sub group by uid, l1, l2;