$2\mathrm{.}17$ 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 $10\mathrm{.}0$ and $20\mathrm{.}0$

BirthDate $-$ date, must be $$ Jan $1,2015$

Make the following updates

Change the height to $15\mathrm{.}6$ for horse with ID $2$

Change the registered name to Lady Luck and birth date to May $1,2015$ for horse with ID $4.$

Change every horse breed to NULL for horses born on or after December $22,2016.$

Note: Your SQL code does not display any results in Develop mode. Use Submit mode to test your code.

$\backslash$table$[[$LAB$,2\mathrm{.}17\mathrm{.}1$: LAB $-$ Update rows in Horse table$]]$

Main.sql

Load default template

$2$ Your SQL statements goes here