DELIMITER //

CREATE PROCEDURE run_sql_statements3a()
BEGIN
    
        SET autocommit = 0;
        START TRANSACTION;
        SElECT dep_delay from flights WHERE carrier = 'UA' and flight_id like '773%';
        SELECT SLEEP(300);
        UPDATE flights
        SET dep_delay = dep_delay + 1
        WHERE carrier = 'UA' and flight_id like '%773%';
        COMMIT;

END //

DELIMITER ;


