D427 Data Management Applications All Lab Solutions Western Governors University

D427 Data Management Applications All Lab Solutions 202
Governors University




D427 ZyBook Exercises

This is a chapter by chapter D427 lab solution guide. Do yourself a favor, try to figure each lab out yourself, google
this if your truly stuck.



Chapter 1 - Relational Databases


Contains 0 labs as of 12/16/2023



Chapter 2 - Complex Queries


Contains 6 labs as of 12/16/2023


2.9 LAB - Select number of movies grouped by year


SELECT Year, COUNT(*) as Total FROM Movie
GROUP BY Year




2.10 LAB - Select movie ratings with leh join


SELECT m.Title, m.Year, r.Description FROM Movie AS m
LEFT JOIN Rating AS r
ON m.RatingCode = r.Code;

, 2.13 LAB - Select lesson schedule with multiple joins


SELECT l.LessonDateTime, s.FirstName, s.LastName, h.RegisteredName FROM LessonSchedule AS l
LEFT JOIN Student AS s

ON l.StudentID = s.ID INNER JOIN Horse AS h
ON l.HorseID = h.ID

WHERE DATE(l.LessonDateTime) = '2020-02-01' ORDER BY l.LessonDateTime, h.RegisteredName;




2.14 LAB - Select tall horses with