Question: 2 . 1 2 LAB - Update rows in Horse table The Horse table has the following columns: ID - integer , auto increment, primary

2
.
1
2
LAB
-
Update rows in 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
>=
1
0
.
0
and
<=
2
0
.
0
BirthDate
-
date, must be
>=
Jan
1
,
2
0
1
5
Make the following updates: Change the height to
1
5
.
6
for horse with ID
2
.
Change the registered name to Lady Luck and birth date to May
1
,
2
0
1
5
for horse with ID
4
.
Change every horse breed to NULL for horses born on or after December
2
2
,
2
0
1
6
.
Note: Your SQL code does not display any results in Develop mode. Use Submit mode to test your code.

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!