1
WGU D427
WGU D427 Final Exam | Data Management –
Applications | Questions & Answers| Grade A|
100% Correct | (Latest 2025/ 2026)
List the last four Pixar movies released (ordered from most recent to least)
Movies Table:
Id
Title
Director
Year
Length_minutes - ANS ✓SELECT Title, Year FROM Movies
ORDER BY Year DESC
LIMIT 4;
List the next five Pixar movies sorted alphabetically
Movies Table:
Id
Title
Director
Year
Length_minutes - ANS ✓SELECT title
FROM movies
ORDER BY title ASC
WGU D427
, 2
WGU D427
LIMIT 5 OFFSET 5;
List all buildings and the distinct employee roles in each building (including empty
buildings)
Buildings Table:
Building_name, Capacity
Employees Table:
Role, Name, Building, Years_employed - ANS ✓SELECT DISTINCT building_name, role
FROM buildings
LEFT JOIN employees
ON building_name = building;
Find the name and role of all employees who have not been assigned to a building
Buildings Table:
Building_name, Capacity
Employees Table:
Role, Name, Building, Years_employed - ANS ✓SELECT name, role FROM employees
WHERE building IS NULL;
Find the names of the buildings that hold no employees
Buildings Table:
Building_name, Capacity
Employees Table:
WGU D427
, 3
WGU D427
Role, Name, Building, Years_employed - ANS ✓SELECT DISTINCT building_name
FROM buildings
LEFT JOIN employees
ON building_name = building
WHERE role IS NULL;
Select the number of movies grouped by year
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 - ANS ✓SELECT count(title), year
FROM movie
GROUP BY year;
Write a SELECT statement to select the Title, Year, and rating Description. Display all
movies, whether or not a ratingcode is available.
Movie Table:
ID - integer, primary key
Title - variable-length string
Genre - variable-length string
Ratingcode - variable-length string
Year - integer
Rating Table:
Code - variable-length string, primary key
WGU D427
, 4
WGU D427
Description - variable-length string - ANS ✓SELECT title, year, description
FROM movie
LEFT JOIN rating
ON ratingcode = code;
Write a SELECT statement to show a list of all employees' first names and their
managers' first names. List only employees that have a manager. Order the results by
Employee first name. Use aliases to give the result columns distinctly different names,
like "Employee" and "Manager".
The Employee table has the following columns:
ID - integer, primary key
Firstname - variable-length string
Lastname - variable-length string
Managerid - integer - ANS ✓SELECT DISTINCT m.firstname as employee, e.firstname as
manager
FROM employee AS e
INNER JOIN employee AS m
ON e.id = m.managerid
ORDER BY m.firstname ASC;
Write a SELECT statement to create a lesson schedule with the lesson date/time, horse
ID, and the student's first and last names. Order the results in ascending order by lesson
date/time, then by horse ID. Unassigned lesson times (student ID is NULL) should not
appear in the schedule.
Horse with columns:
ID - primary key
Registeredname
Breed
Height
WGU D427
WGU D427
WGU D427 Final Exam | Data Management –
Applications | Questions & Answers| Grade A|
100% Correct | (Latest 2025/ 2026)
List the last four Pixar movies released (ordered from most recent to least)
Movies Table:
Id
Title
Director
Year
Length_minutes - ANS ✓SELECT Title, Year FROM Movies
ORDER BY Year DESC
LIMIT 4;
List the next five Pixar movies sorted alphabetically
Movies Table:
Id
Title
Director
Year
Length_minutes - ANS ✓SELECT title
FROM movies
ORDER BY title ASC
WGU D427
, 2
WGU D427
LIMIT 5 OFFSET 5;
List all buildings and the distinct employee roles in each building (including empty
buildings)
Buildings Table:
Building_name, Capacity
Employees Table:
Role, Name, Building, Years_employed - ANS ✓SELECT DISTINCT building_name, role
FROM buildings
LEFT JOIN employees
ON building_name = building;
Find the name and role of all employees who have not been assigned to a building
Buildings Table:
Building_name, Capacity
Employees Table:
Role, Name, Building, Years_employed - ANS ✓SELECT name, role FROM employees
WHERE building IS NULL;
Find the names of the buildings that hold no employees
Buildings Table:
Building_name, Capacity
Employees Table:
WGU D427
, 3
WGU D427
Role, Name, Building, Years_employed - ANS ✓SELECT DISTINCT building_name
FROM buildings
LEFT JOIN employees
ON building_name = building
WHERE role IS NULL;
Select the number of movies grouped by year
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 - ANS ✓SELECT count(title), year
FROM movie
GROUP BY year;
Write a SELECT statement to select the Title, Year, and rating Description. Display all
movies, whether or not a ratingcode is available.
Movie Table:
ID - integer, primary key
Title - variable-length string
Genre - variable-length string
Ratingcode - variable-length string
Year - integer
Rating Table:
Code - variable-length string, primary key
WGU D427
, 4
WGU D427
Description - variable-length string - ANS ✓SELECT title, year, description
FROM movie
LEFT JOIN rating
ON ratingcode = code;
Write a SELECT statement to show a list of all employees' first names and their
managers' first names. List only employees that have a manager. Order the results by
Employee first name. Use aliases to give the result columns distinctly different names,
like "Employee" and "Manager".
The Employee table has the following columns:
ID - integer, primary key
Firstname - variable-length string
Lastname - variable-length string
Managerid - integer - ANS ✓SELECT DISTINCT m.firstname as employee, e.firstname as
manager
FROM employee AS e
INNER JOIN employee AS m
ON e.id = m.managerid
ORDER BY m.firstname ASC;
Write a SELECT statement to create a lesson schedule with the lesson date/time, horse
ID, and the student's first and last names. Order the results in ascending order by lesson
date/time, then by horse ID. Unassigned lesson times (student ID is NULL) should not
appear in the schedule.
Horse with columns:
ID - primary key
Registeredname
Breed
Height
WGU D427
