CREATE TABLE Horse( 
    ID INT AUTO_INCREMENT PRIMARY KEY, 
    RegisteredName VARCHAR(10), 
    Breed VARCHAR(10), 
    Height DECIMAL(3,2), 
    BirthDate DATE
    );

CREATE VIEW HorseBirthdays 
SELECT RegisteredName, BirthDate 
FROM Horse; 

CREATE OR REPLACE VIEW MyHorses AS
SELECT RegisteredName, Height, Breed 
FROM Horse;