Personnel that have the SalariedFlag established to 0 are returned in order because of the BusinessEntityID in ascending buy. In the 2nd example, the result set is purchased with the column TerritoryName in the event the column CountryRegionName is equivalent to 'United States' and by CountryRegionName for all other rows. https://zanerlxbt.bloguetechno.com/fascination-about-hbs-case-study-help-70978748