MySQL Query problem

Table structure (for convenience, I use Chinese directly)
Batch
Product Name
Product Code
Purchase Quantity
Purchase person
Shipping area


My needs are:
One. A summary of the quantity by product code as a classification
Two. On the basis of the rollup, I will summarize each product code by the area of dispatch.

I don't know if I have a description, that is, first of all, I want to summarize the sales quantity of each product, then each product is sorted by the shipping area.

Each query alone, I will, I just want to be able to complete with a query statement

Reply to discussion (solution)

Federated two Queries
Select ...
UNION ALL
Select ...
Order BY Product Code

What does that mean?
Select Product Code, shipping area, sum (purchase quantity) from the TT group by product Code, shipping area;

