Project #56889 - mk assignmnet

Assignment Requirements:

Use the database and tables:

http://enterprise.waltoncollege.uark.edu/ua_dillardsERD.gif

Q1. Create a report of all products made by the brand CLINIQUE. Include the SKU, UPC, and vendor.

Q2. Show a list of all combinations of brands and departments. Show only the brand name and department description in the report—any given combination should only be shown once.

Q3. Which products retail for more than $10? Produce a report of the SKU, brand, and retail value, ordered from least to most expensive.

Q4.    Produce a report of items which sold at a discount of more than $10 (the difference between original and sale prices). Include the items’ UPC number and the amount of the discount, labeled DISCOUNT. Ensure that there are no duplicate results, and that the list is sorted from largest to smallest discount.

Q5.    What total quantity of products from vendor number 3213321 has been sold to date? Label your result column UNITS_SOLD.

Q6.    What is the total dollar amount of sales transactions at any stores in zip code 76116 between October 1, 2004 and December 31, 2004? Label your results TOTAL_SALES.

Q7. Produce a report of the 3 most costly items stocked at any store, ordered from first most expensive to third. Include the cost, SKU, brand, and department description.

Q8.    Which registers have the most and least transactions at store number 303? Include the register numbers, number of transactions, and total sales. Label/alias the fields appropriately.

Q9. Come up with a managerial case/question that can be answered using a complex SQL query (at least 3 tables involved).

 

 

 

Subject Computer
Due By (Pacific Time) 02/09/2015 06:00 am
Report DMCA
TutorRating
pallavi

Chat Now!

out of 1971 reviews
More..
amosmm

Chat Now!

out of 766 reviews
More..
PhyzKyd

Chat Now!

out of 1164 reviews
More..
rajdeep77

Chat Now!

out of 721 reviews
More..
sctys

Chat Now!

out of 1600 reviews
More..
sharadgreen

Chat Now!

out of 770 reviews
More..
topnotcher

Chat Now!

out of 766 reviews
More..
XXXIAO

Chat Now!

out of 680 reviews
More..
All Rights Reserved. Copyright by AceMyHW.com - Copyright Policy