Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

schemas provided need help with sql codes for these - Questions 1- Calculate the average transaction dollar amount of items that are sold on January

image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
schemas provided need help with sql codes for these
- Questions 1- Calculate the average transaction dollar amount of items that are sold on January 1", 2014 2- Calculate the number of returned items during February 14", 2014 3. Calculate the total dollar amount of online sales during 1/1/2014 and 2/14/2014 period 4- Identify the customer number with most frequent purchase transactions during 1/1/2014 and 2/14/2014 period 5- Identify the store number with highest number of returns during 1/1/2014 and 2/14/2014 period 6. Identify the store number with highest dollar amount of returns during 1/1/2014 and 2/14/2014 period 7- Which tender type is generating the highest net revenue for the firm during 1/1/2014 and 2/14/2014 period? 8. Which tender type is generating the highest net revenue for the firm during 1/1/2014 and 2/14/2014 period? Compare across online and in-store sales. 9. Which SKU# is the most frequent item sold during 1/1/2014 and 2/14/2014 period? 10- Which SKUw generates the highest net revenue during 1/1/2014 and 2/14/2014 period? SOLOuery4.sql - es..CL ESa394 SELECT TRAN_TYPE= FROM dbo. TRANSACT WHERE TRAN_DATE='2 Dject Explorer 0x onnect- i * T Yth Indexes # Statistics dbo.TRANSACT Columns TRANSACTION_ID (PK, int, TRAN_DATE (date, not null *** STORE (FK, Smallint, not nu REGISTER (smallint, not nul TRAN_NUM (int, not null) TRAN_TIME (char(4), not nu CUST_ID (FK, int, not null) TRAN_LINE_NUM (smallint, DEPT (smallint, not null) MIC (char(3), not null) SKU (int, not null) TRAN_TYPE (char(1), not nu ORIG_PRICE (decimal(7,2), SALE_PRICE (decimal(7.2), TRAN_AMT (decimal(7,2), TENDER_TYPE (varchar(5), - ITEM_ID (FK, int, not null) ONLINE (char(1), null) Keys 100 % Results Messages TRAN_TYPE 110683 110684 110685 110686 110687 110688 110689 110690 110691 110692 0091 R Query executed successfully O Ready UITS - D2L Brightspace x Dillard's Data SQL Server and x Assignme F C waltonlab.uark.edu/portal/webclient/index.html#/desktop Apps Arbor Webmail TimeClock Plus Ma. O Treasury Managem.. * SQL Query4.sql - essql1.walton.uarkedu.UA_Dillards 2016 (GACLESa394003 (69))* - M File Edit View Project Tools Window Help - 3. New Query M a UA_Dillards_2016 Execute B18 28 Object Explorer X SQLQuery4.sql - es...CL\ESa 394003 (69))* Connect - * * - Oth SELECT TRAN_TYPE='R' FROM dbo. TRANSACT Statistics WHERE TRAN_DATE= '2014-02-14 E dbo.STORE Columns - STORE (PK, smallint, not nu DIVISION (char(2), not null) CITY (varchar(28), not null) STATE (char(2), not null) ZIP CODE (char(5), not null ZIP_SECSEG (char(4), not ni # keys Constraints 100 % # Triggers mm Results Messages Indexes Statistics TRAN_TYPE 110683 E dbo.TRANSACT 110684 Columns 110685 - TRANSACTION JD (PK, int, 110686 TRAN_DATE (date, not null 110687 O STORE (FK, smallint, not nu 110688 REGISTER (smallint, not nul 110689 TRAN_NUM (int, not null) 110690 TRAN_TIME (char(4), not nu 110691 CUST_ID (FK, int, not null) 110692 Query executed successfully. & UITS - D2L Brightspace X Dillard's Data SQL Server and X > C Awaltonlab.uark.edu/portal/webclient/index.html#. Arbor Webmail TimeClock Plus Ma... O Treasury Man SQLQuery4.sql - essql1.walton.uark.edu.UA_Dillards_2016 (GACL\ES File Edit View Project Tools Window Help @-0 3 -3.. . New Query UA_Dillards_2016 | Execute 899 SQL Query4.sql - es...CL\ES ESELECT TRAN_TYP FROM dbo. TRANSA WHERE TRAN_DATE Object Explorer - IX Connect T Y Yo the Indexes # Statistics B dbo.SKU_STORE Columns STORE (PK, FK, smallint, no SKU (PK, int, not null) RETAIL (decimal(7.2), not n COST (decimal(7.2), not nu Keys Constraints # Triggers Indexes Statistics em dbo.STORE Columns STORE (PK, smallint, not nu DIVISION (char(2), not null) CITY (varchar(28), not null) STATE (char(2) not null) 100% Results Messages TRAN_TYPE 110683 110684 110685 110686 110687 UITS - D2L Brightspace X Dillard's Data SQL Server and x Assignments - Acc C waltonlab.uark.edu/portal/webclient/index.html#t/desktop Apps Arbor Webmail TimeClock Plus Ma... Oz Treasury Managem... SACHS SQL Query4.sql-essql1.walton.uark.edu.UA Dillards 2016 (GACLESa 394003 (69)) - Microsoft File Edit View Project Tools Window Help o. 3. -. New Query M X J 2- T UA_Dillards 2016 - Execute 90 B2 28 Object Explorer SQL Query4.sql - es...CLIESa394003 (69))* + x s Connect Y Y Y the SELECT TRAN_TYPE='R' FROM dbo. TRANSACT Statistics WHERE TRAN_DATE='2014-02-14 B dbo.SKU Columns - ITEM_ID (PK, int, not null) SKU (int, not null) DEPT (FK, smallint, null) SKU_CLASS (char(3), null) SKU_STYLE (char(12), null) UPC (decimal(15,0), not nul COLOR (varchar(12), null) SKU_SIZE (char(10), null) 100 % - BRAND NAME (varchar(50 Results Messages CLASSIFICATION (varchar(: PACKSIZE (char(5), null) TRAN_TYPE 110683 110684 Constraints 110685 Triggers 110686 Indexes 110687 Statistics 110688 B dbo.SKU_STORE 110689 2 Columns 110690 - STORE (PK, FK, smallint, no 110691 - SKU (PK, int, not null) 110692 Keys Apps Arbor Webmail TimeClock Plus Ma... O Treasury Ma SQLQuery4.sql - essql1.walton.uarkedu.UA_Dillards_2016 (GACLIES! ile Edit View Project Tools Window Help 0.03 - .. . New Query 2 QAS U A Dillards 2016 - Execute 33 B SQL Query4.sql - es...CL\ES ESELECT TRAN_TYF FROM dbo. TRANSA WHERE TRAN_DATE Object Explorer - IX Connect # B dbo.DEPARTMENT e dbo.Dillards_Returns_l Columns Tran_type (char(1), not null TransAmt (decimal(8,2), nu Online Tran (char(1), null) Tender_Type (char(4), null) DeptCent_Desc (varchar(15 Distance_To_Nearest_Store Division (char(2), null) State_Loc (char(2), null) Keys Constraints Triggers El Indexes Statistics G dbo.DM_1 e Columns I tran_type (char(1), not null) TranAmt (decimal(7.2), null online (char(1), null) 100 % - Results i Messages TRAN_TYPE 110683 110684 110685 110686 110687 110688 110689 110690

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

Database Design And Implementation

Authors: Shouhong Wang, Hai Wang

1st Edition

1612330150, 978-1612330150

More Books

Students also viewed these Databases questions

Question

What is the orientation toward time?

Answered: 1 week ago

Question

4. How is culture a contested site?

Answered: 1 week ago