For each state, return customers (all customers in the state) and revenue (all their order items; 0 if none).
state
customers
revenue
Each hint gives a little more help. Try on your own first.
Run your code to see the output here.