/* sum state income tax collected by state */

select state_code, state_name, sum(tax) 
from payment join state using(state_code)
group by state_code, state_name
order by state_name