Sales by State
select c.company, c.state, paymentmethod, sum(itemstotal) "VALUE"
from customer c join orders o on o.custno=c.custno
group by 1,2,3
order by 1,2,3
Sales by State/Payment
select c.company, c.state, paymentmethod, sum(itemstotal) "VALUE"
from customer c join orders o on o.custno=c.custno
where state in ('AL', 'CA', 'FL', 'OR')
group by 1,2,3
order by 1,2,3