Description

BIAM 530 Week 3 iLab Solutions

Sales by Territory: Query shows Territory ID, Name, Country Region Code, Sales YTD, and Sales Last Year fields for all territories, in descending order by Sales YTD. Analysis and recommendations are reasonable based on query results and are professionally written with no grammar, spelling, or typographical errors.

Sales by Country: Query shows Country Region Code, Total of Sales YTD, and Total of Sales Last Year for each country; totals reflect sums over all territories in each country. Analysis and recommendations are reasonable based on query results and are professionally …..with no grammar, spelling, or typographical errors.   

Sales Growth by U.S. Territory: Query shows Territory ID, Name, Sales YTD, Sales Last Year, and % increase in sales for all territories for which Country Region Code is ‘US’. Analysis and recommendations are reasonable ……on query results and are professionally …..with no grammar, spelling, or typographical errors.  

Best-Selling Products: Query shows the Product ID and sum of Line Total for products having sum of Line Total greater than $2 million, in descending order by sum of Line Total. Analysis and recommendations are reasonable …..on query results and are professionally……..

Best-Selling Products With Product Names: Query shows the Product ID, Product Name, and sum of Line. Total for products having sum of Line Total greater than $2 million. In descending order by sum of LineTotal (i.e., same as the previous query, but with product names shown in addition to product IDs). Analysis and recommendations are reasonable based on query

(THREE VERSION)

BIAM 530 Week 3