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

SELECT AVG(Height) AS AverageHeight 
FROM Horse 
WHERE Height < 17;