Answered step by step
Verified Expert Solution
Question
1 Approved Answer
4 . List CustomerID ( Cust _ ID column ) , City, State, and Zip code ( Zip _ Code column ) for customers from
List CustomerID CustID column City, State, and Zip code ZipCode column for customers from
Austin, Texas who have purchased both Chanel and Armani DeptDesc column perfumecologne
Classification column Sort resultset in ascending order of zip code. Note Please refer to the
Department, SKU, Transact, and Customer tables. There are two types of transactions in the TranType
column: purchase and return, please consider only the purchase transactions. For DeptDesc condition, use
the LIKE operator with Chanel and Armani
Display with appropriate column headings the total purchase amount TranType column and cumulative
purchase amount during each month in TranDate column for Nike DeptDesc column for stores
located in Texas. Note Please refer to the Department, SKU, Transact and Store tables; use condition for
DeptDesc LIKE Nike or LEFTLTRIMDeptDescNike; there are two types of transactions in
the TranType column: purchase and return, please consider only the purchase transactions.
FORMATcolumn nameexpressionC can be used for currency format.
For each store in Texas, list the Store, State, City, Sales Year, Current Year Sales, Last Year Sales, and
Change in Total Yearly Sales between years and As the focus is on sales for years and
for the Last Year Sales and Change in Total Yearly Sales columns include NA for sales year
Display result set in ascending order of store numbers. Note Please refer to the Transact and Store tables;
there are two types of transactions in the TranType column: purchase and return, please consider only the
purchase transactions. FORMATcolumn nameexpressionC can be used for currency format.
Note There are more than rows in the resultset; rows through are shown below.
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started