Employees that have the SalariedFlag set to 0 are returned so as by the BusinessEntityID in ascending get. In the 2nd case in point, The end result set is requested through the column TerritoryName once the column CountryRegionName is equivalent to 'United States' and by CountryRegionName for all other rows. https://lorenzoiofmj.liberty-blog.com/36029338/helping-the-others-realize-the-advantages-of-pay-someome-to-do-case-study