bq024_1.sql

SELECT
state_code,
evaluation_group,
evaluation_description,
state_name,
sum(macroplot_acres) + sum(subplot_acres) as total_acres,
latest
FROM (SELECT
        state_code,
        evaluation_group,
        evaluation_description,
        state_name,
        macroplot_acres,
        subplot_acres,
        MAX(evaluation_group) OVER (PARTITION By state_code) as latest                   
        FROM `bigquery-public-data.usfs_fia.estimated_timberland_acres` )
WHERE evaluation_group = latest
GROUP by state_code, state_name, evaluation_description, evaluation_group, latest
order by state_name
;