Exam 70-461 topic 1 question 253 discussion

DRAG DROP -
You are a developer for a Microsoft SQL Server database that contains a complaint table created by running the following Transact-SQL statement:

Which Transact-SQL statement or statements should you run? To answer, drag the appropriate Transact-SQL statements to the correct functions. Each Transact-
SQL statement may be used once, more than once, or not at all. You may need to drag the split bar between panes or scroll to view content.
Select and Place:

Suggested Answer:
Reference:
https://social.technet.microsoft.com/wiki/contents/articles/17948.t-sql-right-left-substring-and-charindex-functions.aspx https://docs.microsoft.com/en-us/sql/t-sql/language-elements/if-else-transact-sql?view=sql-server-ver15