You could build this into your product node template somehow or add it to the node or add to cart form through a module. The query would simply have to get the SUM() of the qty column for every row in the uc_order_products table with the nid of that node.