Staff members that have the SalariedFlag established to 0 are returned so as with the BusinessEntityID in ascending order. In the 2nd example, the result set is ordered from the column TerritoryName in the event the column CountryRegionName is equal to 'America' and by CountryRegionName for all other rows. From https://cansomeonedomycasestudy28461.sharebyblog.com/35714099/rumored-buzz-on-case-study-help