$4.$ List CustomerID $($Cust$\_$ID column$),$ City, State, and Zip code $($Zip$\_$Code column$)$ for customers from

Austin, Texas who have purchased both Chanel and Armani $($Dept$\_$Desc column$)$ perfume$/$cologne

$($Classification column$).$ Sort result$-$set 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 Tran$\_$Type

column: purchase and return, please consider only the purchase transactions. For Dept$\_$Desc condition, use

the LIKE operator with $\%$Chanel$\%$ and $\%$Armani$\%.)$

$5.$ Display with appropriate column headings the total purchase amount $($Tran$\_$Type column$)$ and cumulative

purchase amount during each month in $2015($Tran$\_$Date column$)$ for Nike $($Dept$\_$Desc column$)$ for stores

located in Texas. $($Note $$ Please refer to the Department, SKU, Transact and Store tables; use condition for

Dept$\_$Desc LIKE $$Nike$\%$ or LEFT$($LTRIM$($Dept$\_$Desc$),4)=$Nike$$; there are two types of transactions in

the Tran$\_$Type column: purchase and return, please consider only the purchase transactions.

FORMAT$($column name$/$expression$,$C$)$ can be used for currency format.$)$

$6.$ 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 $2014$ and $2015.$ As the focus is on sales for years $2014$ and

$2015,$ for the Last Year Sales and Change in Total Yearly Sales columns include $$NA$$ for sales year $2014.$

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 Tran$\_$Type column: purchase and return, please consider only the

purchase transactions. FORMAT$($column name$/$expression$,$C$)$ can be used for currency format.$)$

Note $$ There are more than $100$ rows in the result$-$set; rows $1$ through $30$ are shown below.