Question: I keep running into errors in my SQL code The Horse table has the following columns: - ID - integer, auto increment, primary key -

I keep running into errors in my SQL code
The Horse table has the following columns: - ID - integer, auto increment, primary key - RegisteredName - variable-length string - Breed - variable-length string, must be one of the following: Egyptian Arab, Holsteiner, Quarter Horse, Paint, Saddlebred - Height - decimal number, must be between 10.0 and 20.0 - BirthDate - date, must be on or after Jan 1, 2015 Insert the following data into the Horse table: \( \begin{array}{ll}1 & \text { CREATE TABLE Horse( } \\ 2 & \text { ID INT AUTO_INCREMENT(1,1) PRIMARY KEY, } \\ 3 & \text { RegisteredName VARCHAR(255), } \\ 4 & \text { Breed VARCHAR(255) CHECK (Breed IN ('Egyptian Arab', 'Holsteiner', 'Quarter Horse', 'Paint', } \\ 5 & \text { 'Saddiebred')), } \\ 6 & \text { Height DECIMAL(4,1) CHECK (Height BETWEEN } 10.0 \text { AND 20.0), } \\ 7 & \text { BirthDate DATE CHECK (BirthDate >= '2015-01-01') } \\ 8 & \text { ) ; } \\ 9 & \\ 10 & \text { INSERT INTO Horse VALUES (1, "Babe", 'Quarter Horse', '15.3', "2015-02-10"); } \\ 11 & \text { INSERT INTO Horse VALUES (2, "Independence", 'Holsteiner', '16.0', "2017-03-13"); } \\ 12 & \text { INSERT INTO Horse VALUES (3, "Elite", 'Saddiebred', '15.0', "2016-12-22"); } \\ 13 & \text { INSERT INTO Horse VALUES (4, 'Egyptian Arab', '14.9', "2019-10-12"); } \\ 14 & \text { select RegisteredName, Breed, Height, BirthDate from Horse; }\end{array} \)
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
