1
WGU
WGU C175 EXAM QUESTIONS AND
ANSWERS UPDATED (2024/2025)
(VERIFIED ANSWERS)
Subquery - ANS ✓- When on SELECT statement is "nested" within another in a
format, it is known as subquery. This is shown when there is a second SELECT
phrase within a set of parenthesis.
Common DDL commands: - ANS ✓- DROP
- ALTER
- RENAME
- CREATE
- TRUNCATE
Common DML commands: - ANS ✓- UPDATE
- DELETE
- INSERT
- MERGE
- SELECT
Write the basic SQL query command: - ANS ✓SELECT<columns>
WGU C175
, 2
WGU
FROM<table>
WHERE<predicates identifying rows to be included>
Write the SQL query to "Find the commission percentage and year of hire of
salesperson 186": - ANS ✓SELECT COMMPERCT, YEARHIRE
FROM SALESPERSON
WHERE SPNUM=186;
Write the SQL query to "Retrieve the entire record for salesperson 186": -
ANS ✓SELECT *
FROM SALESPERSON
WHERE SPNUM=186;
Write the SQL query to "List the salesperson numbers and salesperson
names of those salespersons who have a commission percentage of 10.": -
ANS ✓SELECT SPNUM, SPNAME
FROM SALESPERSON
WHERE COMMPERCT=10;
Write the SQL query to "List the salesperson numbers, salesperson names,
and commission percentages of the salespersons whose commission
percentage is less than 12.": - ANS ✓SELECT SPNUM, SPNAME, COMMPERCT
FROM SALESPERSON
WGU C175
, 3
WGU
WHERE COMMPERCT<12;
Write the SQL query to "List the customer numbers and headquarters cities
of all customers that have a customer number of at least 1700": - ANS
✓SELECT CUSTNUM, HQCITY
FROM CUSTOMER
WHERE CUSTNUM>=1700;
Write the SQL query to "List the customer numbers, customer names, and
headquarters cities of the customers that are headquartered in New York
and that have a customer number higher than 1500": - ANS ✓SELECT
CUSTNUM, CUSTNAME, HQCITY
FROM CUSTOMER
WHERE HQCITY='New York'
AND CUSTNUM>1500;
Write the SQL query to "List the customer numbers, customer names, and
headquarters cities of the customers that are headquartered in New York
OR that have customer numbers higher than 1500": - ANS ✓SELECT
CUSTNUM, CUSTNAME, HQCITY
FROM CUSTOMER
WHERE HQCITY='New York'
OR CUSTNUM>1500;
WGU C175
WGU
WGU C175 EXAM QUESTIONS AND
ANSWERS UPDATED (2024/2025)
(VERIFIED ANSWERS)
Subquery - ANS ✓- When on SELECT statement is "nested" within another in a
format, it is known as subquery. This is shown when there is a second SELECT
phrase within a set of parenthesis.
Common DDL commands: - ANS ✓- DROP
- ALTER
- RENAME
- CREATE
- TRUNCATE
Common DML commands: - ANS ✓- UPDATE
- DELETE
- INSERT
- MERGE
- SELECT
Write the basic SQL query command: - ANS ✓SELECT<columns>
WGU C175
, 2
WGU
FROM<table>
WHERE<predicates identifying rows to be included>
Write the SQL query to "Find the commission percentage and year of hire of
salesperson 186": - ANS ✓SELECT COMMPERCT, YEARHIRE
FROM SALESPERSON
WHERE SPNUM=186;
Write the SQL query to "Retrieve the entire record for salesperson 186": -
ANS ✓SELECT *
FROM SALESPERSON
WHERE SPNUM=186;
Write the SQL query to "List the salesperson numbers and salesperson
names of those salespersons who have a commission percentage of 10.": -
ANS ✓SELECT SPNUM, SPNAME
FROM SALESPERSON
WHERE COMMPERCT=10;
Write the SQL query to "List the salesperson numbers, salesperson names,
and commission percentages of the salespersons whose commission
percentage is less than 12.": - ANS ✓SELECT SPNUM, SPNAME, COMMPERCT
FROM SALESPERSON
WGU C175
, 3
WGU
WHERE COMMPERCT<12;
Write the SQL query to "List the customer numbers and headquarters cities
of all customers that have a customer number of at least 1700": - ANS
✓SELECT CUSTNUM, HQCITY
FROM CUSTOMER
WHERE CUSTNUM>=1700;
Write the SQL query to "List the customer numbers, customer names, and
headquarters cities of the customers that are headquartered in New York
and that have a customer number higher than 1500": - ANS ✓SELECT
CUSTNUM, CUSTNAME, HQCITY
FROM CUSTOMER
WHERE HQCITY='New York'
AND CUSTNUM>1500;
Write the SQL query to "List the customer numbers, customer names, and
headquarters cities of the customers that are headquartered in New York
OR that have customer numbers higher than 1500": - ANS ✓SELECT
CUSTNUM, CUSTNAME, HQCITY
FROM CUSTOMER
WHERE HQCITY='New York'
OR CUSTNUM>1500;
WGU C175
