Find the total number of transactions and transaction amount in Nov 2007) for SIC 56 by SCF code...

Question

Find the total number of transactions and transaction amount in Nov 2007) for SIC 56 by SCF code (first 3 digits of the zip code). (20 points) 5. We need to segment the customers by customer spending behavior based upon ) number of transactions, ii) total dollar amount iii) SIC penetration, and iv) spending categories. You need to develop 5 clusters (A, B, C, D, and E) with the following characteristics: A totalSIC.Count >8, count SIC54 >0, count SIC53 > • B totalSic Count >= 5, total Visits. > 1 totalValume. 0. count SIC 55 > E Else Your output needs to have Customer ID and Cluster only. (25 points) TRANSACTION Merchant_ID Merchant_Name Merchant_SIC Merchant Zip Customer_Name Customer_Address Customer City Customer State Customer Zip Tran_Date Trans_Amount EXISTING CUSTOMER Customer 10 Customer_FirstName Customer_LastName Address_1 Address_2 City State Zip Country.

Aditi · Accepted Answer

SOLUTION
a. SELECT COUNT(Customer_ID) as Nbr_Customers, SUM(Trans_Amount) as 
Total_Amount, Substring(Merchant_Zip,1,3) as SCF_Code
FROM TRANSACTION 
WHERE Month(Tran_Date) = 11 AND Year(Tran_Date) = 2007 AND Merchant_SIC 
LIKE '56%'
GROUP BY Substring(Merchant_Zip,1,3) as SCF_Code
b.

Find the total number of transactions and transaction amount in Nov 2007) for SIC 56 by SCF code (first 3 digits of the zip code). (20 points) 5. We need to segment the customers by customer spending...

Solution

Answer To This Question Is Available To Download

Related Questions & Answers

Submit New Assignment