Staff members that have the SalariedFlag established to 0 are returned as a way by the BusinessEntityID in ascending buy. In the 2nd case in point, the result set is purchased through the column TerritoryName once the column CountryRegionName is equivalent to 'U.s.' and by CountryRegionName for all other rows. https://jasperrkoxh.wizzardsblog.com/35841788/helping-the-others-realize-the-advantages-of-hbs-case-solution