MAX MIN

[pstanek]

I have table with columns

Office -Product-  Stock Value.

I need to create  Product - MIN Stock - Office with min stock - Max stock - Office with max stock

I try to avoid to order new products for one office, when another has too many products.

For example product_i was sold out by one office, another could sell only few product.

Do you have any idea?

Another step should be identifying products with largest Max stock - Min Stock.