Engineering
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 2 10. 0 and < 20. 0 BirthDate - date, must be > Jan 1, 2015 Make the following updates: 1. Change the height to 15. 6 for horse with ID 2. 2. Change the registered name to Lady Luck and birth date to May 1, 2015 for horse with ID 4. 3. Change every horse breed to NULL for horses born on or after December 22, 2016. 302990. 1511538. Gx3zgy7 LAB 12. 16. 1: Update rows in Horse table ACTIVITY Main. Sql Load default 1 UPDATE Horse 2 SET Height = 15. 6 3 WHERE ID = 2; 4 5 UPDATE Horse 6 SET RegisteredName = 'Lady Luck', BirthDate = '2015-05-01' 7 WHERE ID = 4; 8 9 UPDATE Horse 10 SET Breed = NULL 11 WHERE BirthDate >= '2016-22-12'; 12 13 14 15 -- Leave this query for testing 16 SELECT * 17 FROM Horse 18 ORDER BY ID;