need sql code for question number 4

ds_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 SKUw 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