BenchMark Quizzes by MDFT Pro

Choose the correct T-SQL function

You are working as a data analyst for MDFT Pro, a well-known training agency. The academy uses a Fabric warehouse to track their training course sales. The warehouse contains a table named Courses that stores information about their training courses. The table contains the following columns.

Name	Datatype	Nullable
CourselD	Integer	No
CourseName	Decimal(18, 2)	No
ListPrice	Decimal(18, 2)	No
WholesalePrice	Decimal(18, 2)	Yes
AgentPrice	Decimal(18, 2)	Yes

Your manager has asked you to write a T-SQL query that will return the following columns to help analyze course pricing.

Name	Description
CourseID	Return the CourseID value
HighestPrice	Returns the highest value from ListPrice, WholesalePrice and AgentPrice
TradePrice	Returns AgentPrice if present, otherwise returns WholesalePrice if present, otherwise returns ListPrice

You have the following T-SQL query:

SELECT 
    CourseID, 
    ________________ (ListPrice, WholesalePrice, AgentPrice) AS HighestPrice
FROM Courses

How should you complete the query?

Choose the correct answer from the options below.

Explanations for each answer:

COALESCE is incorrect. COALESCE returns the first non-null value from a list of expressions, not the highest value
CHOOSE is incorrect. CHOOSE returns a value from a list based on an index position, not for comparing values
GREATEST is correct.
IIF is incorrect. IIF is a conditional function that returns one of two values based on a condition, not for finding maximum values
MAX is incorrect. MAX is an aggregate function that finds the maximum value in a column, not for comparing values across multiple columns

Learn more about T-SQL logical functions:

T-SQL Logical Functions

Exam Preparation Quiz

Choose the correct T-SQL function