How would you modify this procedure to return both the sum and product of two numbers?
CREATE PROCEDURE calc(IN a INT, IN b INT, OUT sum INT)
BEGIN
SET sum = a + b;
END;
AReturn product using a SELECT statement instead of OUT parameter.
BChange sum parameter to INOUT and calculate product inside.
CAdd another OUT parameter for product and set it inside the procedure.
DUse only IN parameters and calculate product outside the procedure.
