Wgu - D427 Data Management - Applications Zybooks Labs 7 And 8 Study Guide Questions And Correct Answers

8.16 Practice Lab 16 The Movie table has the following columns: ID—integer, primary key Title—variable-length string Genre—variable-length string RatingCode—variable-length string Year—integer The YearStats table has the following columns: Year—integer TotalGross—bigint unsigned Releases—integer Write a SQL query to display both the Title and the TotalGross (if available) for all movies. Ensure your result set returns the columns in the order indicated. {Ans: SELECT Title, TotalGross FROM Movie LEFT JOIN YearStats ON Movie.Year = YearStats.Year;}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 Horse SET Breed = NULL WHERE BirthDate >= '2016-12-22';}7.7 LAB - Create Student table with