Create a measure for sql subquery

[chakri545]

Hello everyone i’m trying to write a SQL subquery in looker model but i’m getting error on Athena side can somebody please let me know how to contruct this in looker SQL block

select name, sum(a.goal) from
(
  select name, line_item_id, max(goal) as goal from reporting_tbl
group by name, line_item_id
 ) a
group by a.name