Staff which have the SalariedFlag established to 0 are returned so as because of the BusinessEntityID in ascending get. In the 2nd instance, the result established is requested with the column TerritoryName once the column CountryRegionName is equal to 'United States' and by CountryRegionName for all other rows. Social Functionality: https://rowanoigdj.answerblogs.com/36106737/the-definitive-guide-to-online-case-solution