The operate returns the initial and final name of the offered BusinessEntityID along with the Make contact with type for that person. The CASE expression inside the Established assertion determines the value to Screen to the column ContactType determined by the existence from the BusinessEntityID column in the worker, Seller, https://griffinufxwl.bcbloggers.com/34980432/everything-about-hbr-case-solution