Which three Transact-SQL segments should you use to develop the solution?

DRAG DROP
You have a Microsoft SQL Server database. The database contains a group of tables created by using the following Transact-SQL statements:

You need to write a query that returns all the salesperson’s phone numbers and an indicator as to whether you can contact the salesperson using that number. The indicator must meet the following requirements:
• If the phone number is a work phone number, the indicator should show the value ‘Allow Calls’.
• If the phone number is NULL, the indicator should show the value ‘Unrecognized Phone Type’.
• In all other cases, the indicator should show the value ‘Do Not Call’.
Which three Transact-SQL segments should you use to develop the solution? To answer, move the appropriate Transact-SQL segments from the list of Transact-SQL segments to the answer area and arrange them in the correct order.
Select and Place:

Correct Answer:

Explanation/Reference:
Explanation:
FROM COALESCE IIF
Box 1: SELECT
Box 2: COALESCE
COALESCE evaluates the arguments in order and returns the current value of the first expression that initially doesn’t evaluate to NULL.
Box 3: FROM …
References:
https://docs.microsoft.com/en-us/sql/t-sql/language-elements/coalesce-transact-sql