max_by.sql

max_by.md

WITH data as (
  select 'jake' as name, 18 as age
  union all
  select 'tom' as name, 64 as age
  union all
  select 'lisa' as name, 32 as age
  union all
  select 'justin' as name, 43 as age
)
select
  -- max_by(name, age) as name
  max(named_struct('age',age,'name',name)).name as name
from
  data;