CREATE TABLE School( 
    SchoolID INT UNSIGNED, 
    SchoolName VARCHAR(50), 
    DateConstructed DATE, 
    OperatingBudget DECIMAL(3,1) UNSIGNED,  
    Classification VARCHAR(1),
    President VARCHAR(20)
    );

SHOW COLUMNS 
FROM School;