I have a table with order information that looks like this

I would Like to summarize May Demand by Status and category

the Member Column is not needed, just added it for logic clarity I have worked out some of the logic below

Further Explanation

Open to Logic in sql or python! Just having a hard time with the steps of getting from table a to table b

Thanks in advance !