Answered step by step
Verified Expert Solution
Question
1 Approved Answer
3.9 LAB - Insert rows into Horse table The Horse table has the following columns: . ID - integer, auto increment, primary key RegisteredName -
3.9 LAB - Insert rows into Horse table 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: RegisteredName Breed Height BirthDate Babe Quarter Horse |15.3 2015-02-10 Independence Holsteiner 16.0 2017-03-13 Ellie Saddlebred 15.0 2016-12-22 NULL Egyptian Arab 14.9 2019-10-12 430856.3010638.qx3zzyz LAB ACTIVITY 3.9.1: LAB - Insert rows into Horse table 0 / 10 Main.sql Load default template.. 1. UPDATE horse SET height = 15.6 WHERE id = 2; 2. UPDATE horse SET registeredname = 'Lady Luck' , birthdate = '2015-05-01' WHERE id = 4; 10 11 3. 12 UPDATE horse SET breed = NULL WHERE birthdate >= '2016-12-2
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access with AI-Powered Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started