IF statement

Here's a procedure named shopping. Copy this template into the input field and replace ToDo... with the correct IF statements.

CREATE PROCEDURE shopping(
    item_name VARCHAR(30),
    color VARCHAR(30))
BEGIN
    # ToDo...
INSERT INTO basket (item) VALUES (item_name);
END IF;
END;

Write IF statement that will add only red color items to the basket.

There are some calls below that should successfully work with this procedure. Take a look at their parameters to understand how to write the IF statement correctly.

CALL shopping('jacket', 'green');

CALL shopping('hat', 'red');

CALL shopping('pants', 'red');