Summary For this assignment, we will continue with the AdventureWorks2022 database. All of these queries will...

Transcribed Image Text:

Summary For this assignment, we will continue with the AdventureWorks2022 database. All of these queries will require sub queries and my require joins and aggregate functions. Again, pay close attention each question. These will require you to understand how the table is organized and the meaning of each column. Specifications 1. The Marketing department is strategizing on uplifting underperforming products and needs insights into each product's performance. Could you provide a list detailing the total sales amount for each product to help identify the areas that require focus? a. 504 Results 2. Human Resources is planning to recognize and reward the top-performing sales employee of the company. Could you retrieve the details, including ID and name, of the employee who has achieved the highest number of sales to facilitate this acknowledgment? a. 17 Results 3. The Inventory Management team is refining stock levels and requires insights into product demands. Could you provide information on the average order quantity for each product category to help optimize inventory and avoid stockouts or overstock situations? a. 37 Results 4. The Sales department is interested in identifying and analysing high-value customers. Could you provide a list of customers who have placed orders with a total value greater than the average order value across all customers? a. 2020 Results 5. The Inventory Management team is reviewing the stock levels of products. Could you find products whose stock level is below the average stock level across all products to ensure timely replenishments? a. 323 Results 6. Human Resources and Sales Management aim to implement targeted training programs. Could you identify employees whose total sales are below any of the top three salespeople to determine the candidates for the program? a. 17 Results 7. The Marketing Team is strategizing targeted promotions. Could you identify customers in each territory who have an above-average order frequency to tailor promotions effectively? a. 7470 Results 8. The Sales department wants to identify and reward the top customers from each region based on their total purchase amount. Could you provide a list of such customers along with the regions and their total purchases? a. 10 Results 9. The Product Management team needs to highlight successful products in each category. Could you identify products that have total sales above the average in their respective categories? a. 107 Results 10. The Supply Chain department wants to optimize inventory levels and ensure that products are not understocked. They need a list of products that have lower stock levels than the average stock level of products in the same product subcategory. a. 1 Result Summary For this assignment, we will continue with the AdventureWorks2022 database. All of these queries will require sub queries and my require joins and aggregate functions. Again, pay close attention each question. These will require you to understand how the table is organized and the meaning of each column. Specifications 1. The Marketing department is strategizing on uplifting underperforming products and needs insights into each product's performance. Could you provide a list detailing the total sales amount for each product to help identify the areas that require focus? a. 504 Results 2. Human Resources is planning to recognize and reward the top-performing sales employee of the company. Could you retrieve the details, including ID and name, of the employee who has achieved the highest number of sales to facilitate this acknowledgment? a. 17 Results 3. The Inventory Management team is refining stock levels and requires insights into product demands. Could you provide information on the average order quantity for each product category to help optimize inventory and avoid stockouts or overstock situations? a. 37 Results 4. The Sales department is interested in identifying and analysing high-value customers. Could you provide a list of customers who have placed orders with a total value greater than the average order value across all customers? a. 2020 Results 5. The Inventory Management team is reviewing the stock levels of products. Could you find products whose stock level is below the average stock level across all products to ensure timely replenishments? a. 323 Results 6. Human Resources and Sales Management aim to implement targeted training programs. Could you identify employees whose total sales are below any of the top three salespeople to determine the candidates for the program? a. 17 Results 7. The Marketing Team is strategizing targeted promotions. Could you identify customers in each territory who have an above-average order frequency to tailor promotions effectively? a. 7470 Results 8. The Sales department wants to identify and reward the top customers from each region based on their total purchase amount. Could you provide a list of such customers along with the regions and their total purchases? a. 10 Results 9. The Product Management team needs to highlight successful products in each category. Could you identify products that have total sales above the average in their respective categories? a. 107 Results 10. The Supply Chain department wants to optimize inventory levels and ensure that products are not understocked. They need a list of products that have lower stock levels than the average stock level of products in the same product subcategory. a. 1 Result

Answer rating: 100% (QA)

Answer SELECT eBusinessEntityID pFirstName pLastName FROM HumanResourcesEmployee AS e INN... View the full answer