Exam 70-461 topic 1 question 227 discussion

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:

Suggested Answer:
References:
https://docs.microsoft.com/en-us/sql/t-sql/language-elements/coalesce-transact-sql