Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

-7K12911 X + File - Where Companies Conn. X ShareFile - Where Companie X Home Actions - View - Communicate - - Files & Extras

image text in transcribed
-7K12911 X + File - Where Companies Conn. X ShareFile - Where Companie X Home Actions - View - Communicate - - Files & Extras C launchservicing.sharefile.com/share/view/sb leoc 3f3ae6450e9 erview Questions_Short_V1.pdf 7. Display the top three selling products, in 2008, for each of the sub categories listed below: Mountain bikes, Road bikes and Touring bikes. Sample result shown below Sub Category Product name Total sales Mountain Bikes Mountain Bikes Mountain Bikes 8. Find products that were sold every single month from 07/01/2005 - 07/31/2008 and display their total sales amount and units sold to date. Sample result shown below Product Name Total Sales Total Units Sold 9. Which is the bestselling Mountain Bike? Show the historic pricing for this product and total sales and units sold at each price point. Note: [ProductlistpriceHistory] table has the historic prices. ProductSubcategoryid =1 for Mountain bike. Sample result shown below Productid Product Name Total Sales Price Start Date Price End Date List Price Total Sales Total Units Page 2 of 2

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Quantitative Analysis For Management

Authors: Barry Render, Ralph M. Stair, Michael E. Hanna

11th Edition

9780132997621, 132149117, 132997622, 978-0132149112

More Books

Students also viewed these General Management questions