WGU - D427|Data Management-Applications|Pre-Assessment:66
Updated Questions and Answers|100% Correct|New Version.
Correct 66
100%
Incorrect 00
Next steps
Your answers
1 of 66
Definition
SELECT grade, COUNT(*)
FROM student_grades
GROUP BY grade;
Give this one a try later!
, 43. Write a SQL statement to retrieve all of the Customers from Seattle from the
table below.
53. Using the student_grades table listed above, write a query to count how
many students have each grade (A, B, and C).
MODELS TABLE
model_id
26. The Book table has the following columns:
ID—integer, primary key, auto_increment
Title—variable-length string Genre—
variable-length string Year—integer
Write a SQL query to display all Title values in alphabetical order A-Z.
47. Write a query that will return all of the cities from the Customer table above. Do
not include duplicates -list each city only once.
Don't know?
2 of 66
Term
Which query illustrates performing an outer join of the Movie table
with a different table?
- SELECT M.Title, A.Actor FROM Movie M, Actor A
WHERE M.ActorID = A.ID
,- SELECT M.Title, A.Actor FROM Movie M
LEFT JOIN Movie MB ON M.ID, Actor A
- SELECT M.Title, A.Actor FROM Movie M
RIGHT JOIN Actor A ON M.ActorID = A.Id
- SELECT M.Title, A.Actor FROM Movie M
INNER JOIN Actor A ON M.ActorID = A.ID
Give this one a try later!
SELECT Title, TotalSales
SELECT Title, Genre
FROM Book
FROM Book
LEFT JOIN YearStats ON Book.Year =
WHERE Year = 2020;
YearStats.Year;
SELECT M.Title, A.Actor FROM SELECT M.Title, A.Name
Movie M FROM Movie M
LEFT JOIN Movie MB ON M.ID RIGHT JOIN Actor A ON M.ActorID =
Actor A A.ActorID;
Don't know?
3 of 66
, Term
2. The Patient table has the following columns:
first_name varchar(20)
last_name varchar (30)
birthdate date
patient_id int
Which column should be designated as the primary key for the Patient
table?
- first_name
- last_name
- birthdate
- patient_id
Give this one a try later!
SELECT COUNT (*)
FROM Book DATETIME
WHERE Year = 2019;
UPDATE Song
SET Year = 2022 patient_id
WHERE Year = 2020;
Don't know?
Updated Questions and Answers|100% Correct|New Version.
Correct 66
100%
Incorrect 00
Next steps
Your answers
1 of 66
Definition
SELECT grade, COUNT(*)
FROM student_grades
GROUP BY grade;
Give this one a try later!
, 43. Write a SQL statement to retrieve all of the Customers from Seattle from the
table below.
53. Using the student_grades table listed above, write a query to count how
many students have each grade (A, B, and C).
MODELS TABLE
model_id
26. The Book table has the following columns:
ID—integer, primary key, auto_increment
Title—variable-length string Genre—
variable-length string Year—integer
Write a SQL query to display all Title values in alphabetical order A-Z.
47. Write a query that will return all of the cities from the Customer table above. Do
not include duplicates -list each city only once.
Don't know?
2 of 66
Term
Which query illustrates performing an outer join of the Movie table
with a different table?
- SELECT M.Title, A.Actor FROM Movie M, Actor A
WHERE M.ActorID = A.ID
,- SELECT M.Title, A.Actor FROM Movie M
LEFT JOIN Movie MB ON M.ID, Actor A
- SELECT M.Title, A.Actor FROM Movie M
RIGHT JOIN Actor A ON M.ActorID = A.Id
- SELECT M.Title, A.Actor FROM Movie M
INNER JOIN Actor A ON M.ActorID = A.ID
Give this one a try later!
SELECT Title, TotalSales
SELECT Title, Genre
FROM Book
FROM Book
LEFT JOIN YearStats ON Book.Year =
WHERE Year = 2020;
YearStats.Year;
SELECT M.Title, A.Actor FROM SELECT M.Title, A.Name
Movie M FROM Movie M
LEFT JOIN Movie MB ON M.ID RIGHT JOIN Actor A ON M.ActorID =
Actor A A.ActorID;
Don't know?
3 of 66
, Term
2. The Patient table has the following columns:
first_name varchar(20)
last_name varchar (30)
birthdate date
patient_id int
Which column should be designated as the primary key for the Patient
table?
- first_name
- last_name
- birthdate
- patient_id
Give this one a try later!
SELECT COUNT (*)
FROM Book DATETIME
WHERE Year = 2019;
UPDATE Song
SET Year = 2022 patient_id
WHERE Year = 2020;
Don't know?
