Employees which have the SalariedFlag established to 0 are returned as a way through the BusinessEntityID in ascending order. In the 2nd case in point, The end result set is requested with the column TerritoryName once the column CountryRegionName is equal to 'Usa' and by CountryRegionName for all other rows. https://case-study-analysis30197.jts-blog.com/34797901/rumored-buzz-on-hbr-case-studies