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
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
