Question

1 Approved Answer

Posted on Aug 22, 2024

need question 5 and 6 donot understand which two tables to join maybe store table snd transact but not sure at all how to write

need question 5 and 6 donot understand which two tables to join maybe store table snd transact but not sure at all how to write this to get answer to these teo questions image text in transcribed

1. Calculate the average transaction dollar amount of items that are sold on January 15, 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 SKUN 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? SQLQuery4.sql - es...CL\ESa394 SELECT TRAN_TYPE= FROM dbo. TRANSACT WHERE TRAN_DATE='2 Dject Explorer IX onnect- * T Y the Indexes # Statistics o 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 O 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 110692R R Query executed successfully. O Ready Apps Arbor Webmail TimeClock Plus Ma... O Treasury Ma SQLQuery4.sql - essql1.walton.uark.edu.UA_Dillards_2016 (GACLIES! ile Edit View Project Tools Window Help 0-03-3.. . New Query 2 AOS UA Dillards 2016 - Execute 38 3 SQL Query4.sql - es...CL\ES ESELECT TRAN_TYF FROM dbo. TRANSA WHERE TRAN_DATE Object Explorer IX Connect You dbo.DEPARTMENT 3 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 il Indexes Statistics dbo.DM_1 El Columns tran_type (char(1), not null) TranAmt (decimal(7.2), null online (char(1), null) 100 % Results Messages TRAN_TYPE 110683 110684 110685 110686 110687 110688 110689 110690 UITS - D2L Brightspace X Dillard's Data SQL Server and X > C Awaltonlab.uark.edu/portal/webclient/index.html#. Apps Arbor W 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 3 ConneX SQL Query4.sql - es...CLES SELECT TRAN_TYP FROM dbo. TRANSA WHERE TRAN_DATE Object Explorer - IX Connect 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 e 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 gi 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#/desktop Apps Arbor Webmail TimeClock Plus Ma... O Treasury Managem.. ACH SQL Query4.sql-essqi1.walton.uark.edu.UA Dillards 2016 (GACLESa 394003 (69)) - Microsoft File Edit View Project Tools Window Help 0. 3.. New Query X a 2- UA_Dillards_2016 - Execute 899 28 Object Explorer SQLQuery4.sql - es...CLES 394003 (69))* + x s Connect - Y YY Y 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 Keys 110684 Constraints 110685 Triggers 110686 Indexes 110687 Statistics 110688 B dbo.SKU_STORE 110689 B Columns 110690 STORE (PK, FK, smallint, no 110691 - SKU (PK, int, not null) 110692 R Apps Arbor Webmail TimeClock Plus Ma... O Treasury Ma SQLQuery4.sql - essql1.walton.uark.edu.UA_Dillards_2016 (GACLIES! ile Edit View Project Tools Window Help 0-03-3.. . New Query 2 AOS UA Dillards 2016 - Execute 38 3 SQL Query4.sql - es...CL\ES ESELECT TRAN_TYF FROM dbo. TRANSA WHERE TRAN_DATE Object Explorer IX Connect You dbo.DEPARTMENT 3 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 il Indexes Statistics dbo.DM_1 El Columns tran_type (char(1), not null) TranAmt (decimal(7.2), null online (char(1), null) 100 % Results Messages TRAN_TYPE 110683 110684 110685 110686 110687 110688 110689 110690 UITS - D2L Brightspace x Dillard's Data SQL Server and x Assignments - Acc C waltonlab.uark.edu/portal/webclient/index.html#/desktop Apps Arbor Webmail TimeClock Plus Ma... O Treasury Managem.. ACH SQL Query4.sql-essqi1.walton.uark.edu.UA Dillards 2016 (GACLESa 394003 (69)) - Microsoft File Edit View Project Tools Window Help 0. 3.. New Query X a 2- UA_Dillards_2016 - Execute 899 28 Object Explorer SQLQuery4.sql - es...CLES 394003 (69))* + x s Connect - Y YY Y 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 Keys 110684 Constraints 110685 Triggers 110686 Indexes 110687 Statistics 110688 B dbo.SKU_STORE 110689 B Columns 110690 STORE (PK, FK, smallint, no 110691 - SKU (PK, int, not null) 110692 R 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... A * File SQL Query4.sql-essql1.walton.uark.edu.UA_Dillards 2016 (GACLES 394003 (69))* - M Edit View Project Tools Window Help 3.3. New Query 2 . MA J A UA_Dillards_2016 Execute > 1828 SQL Query4.sql - es...CL\ESa394003 (69))* SELECT TRAN_TYPE='R' FROM dbo. TRANSACT WHERE TRAN_DATE='2014-02-14 Object Explorer IX Connect - Y Y Yo the Statistics B 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 nu Keys Constraints # Triggers Indexes Statistics E dbo.TRANSACT B Columns - TRANSACTION_ID (PK, int, TRAN_DATE (date, not null O STORE (FK, smallint, not nu REGISTER (smallint, not nul TRAN_NUM (int, not null) TRAN_TIME (char(4), not ni - CUST_ID (FK, int, not null) 100 % mm Results Messages TRAN_TYPE 110683 110684 110685 110686 110687 110688 110689 110690 110691 110692 Query executed successfully