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