Oh my god. Well it’s clear that being away from coding for 6 months has sapped what little skills I had from my brain.
Thanks. The final product:
SELECT SUM(project.funding_amt) AS totals
, project.proj_year
, state.state_name
FROM project
INNER JOIN state
ON state.code = project.state
WHERE funding_amt > 0
GROUP BY proj_year, state.state_name
ORDER BY proj_year, state.state_name