Wgu - D427 Data Management - Applications Zybooks Labs 7 And 8 Exam Questions (27 Terms) With Verified Definitions Updated 2024

7.5 LAB - Select horses with logical operators The Horse table has the following columns: ID - integer, primary key RegisteredName - variable-length string Breed - variable-length string Height - decimal number BirthDate - date Write a SELECT statement to select the registered name, height, and birth date for only horses that have a height between 15.0 and 16.0 (inclusive) or have a birth date on or after January 1, 2020. {Ans: SELECT RegisteredName, Height, BirthDate FROM Horse WHERE (Height BETWEEN 15.0 AND 16.0) OR (BirthDate >= '2020-01-01');}7.3 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.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 {Ans: UPDATE Horse SET Height = 15.6 WHERE ID = 2; UPDATE Horse SET RegisteredName = 'Lady Luck', BirthDate = '2015-05-01' WHERE ID = 4; UPDATE