AdventureWorks2019-Analysis-T-SQL-

---

Problem:
Question 1: Display the business entity, territory and sales details. Also categories Bonus using the following criteria;

If Bonus<1000 then that is a lowbonus

If Bonus is between 1000 and 2000 inclusive then that is a midbonus

If Bonus > 2000 that is a high bonus

Question 2: Find the TotalSales of each bonus category defined in question 1. HINT: Use SELECT INTO and Subquery.

Question 3: Create a function such that if a user passes in a store id it returns the each product id, name of the product and the line total of that product.

Question 4: For each Job title show the number of employees, mean age and mean rate. Use a temp table inside a stored procedure

---

Solutions: Click SQL Script to view the solutions

session_clip.mp4