0
0 Comments

im trying to create this store procedure that lets you input the customer ID number and it will output the highest order total and the customer firsts and last name. this is what i got so far cant seem to get what the error is

 DELIMITER //   
CREATE PROCEDURE CustomerHighestOrders(IN CustomerID VARCHAR(3), OUT HighestOrder DECIMAL)
    BEGIN 
        SELECT 
                c.FirstName,
                c.LastName
                MAX(o.TotalPrice)
            INTO 
                HighestOrder
        FROM 
            orders AS o
        JOIN 
            customer AS c USING(CID)
        WHERE CustomerIDNumber = o.CID;
    END //
Anonymous Asked question May 14, 2021