---

-- 3.f.i.1. Добавляем поле
ALTER TABLE TEAM ADD COLUMN Km CHAR(4);

DELIMITER //
-- 3.f.i.2. Триггер
CREATE TRIGGER tr_auto_km_team
BEFORE INSERT ON TEAM
FOR EACH ROW
BEGIN
    -- Берём 1-й символ и последний символ названия
    SET NEW.Km = CONCAT(LEFT(NEW.team_name, 1), RIGHT(NEW.team_name, 1));
END //
DELIMITER ;

-- Проверка:
INSERT INTO TEAM (team_name) VALUES ('Development');
SELECT team_name, Km FROM TEAM WHERE team_name = 'Development'; -- Km = 'Dt'