Use your own database and provide the screen shot of the query and output.
Q1. Write a view to join Product and product line to group by Productline to show the sum of MSRP price
Q2. Write a query to show which customer has the biggest order (spend maximum money) and which products are making good business for the organization
Q3. Write a stored procedure to pass a product to find if there is any order on that product or not
Q4. Create a new field called 'Rating' and give a scale in 1-10 order for best to worst depending on how the product has done the business
Hint - which product sold the most and least. Write a cursor to give the rating in new fields
Q5. Write a query to find which customer has paid the for their order which didn't/ Provide a list