What is the total production of the product that is ordered in the highest quantity in order no. 10248?
total production of the product = SUM(units in stock, units on order); order no. refers to OrderID;
SELECT T1.UnitsInStock + T1.UnitsOnOrder FROM Products AS T1 INNER JOIN `Order Details` AS T2 ON T1.ProductID = T2.ProductID WHERE T2.OrderID = 10248 ORDER BY T2.Quantity DESC LIMIT 1