Employees that have the SalariedFlag established to 0 are returned so as because of the BusinessEntityID in ascending purchase. In the 2nd case in point, the result set is purchased with the column TerritoryName once the column CountryRegionName is equivalent to 'United States' and by CountryRegionName for all other rows. https://sethzkzzn.blogprodesign.com/57166724/buy-case-study-solution-fundamentals-explained