4. 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 i) 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 totalSICCount >6, countSIC54 >0, countSIC53 >0 totalSICCount >= 5, totalVisits >1 totalVolume 0, countSIC55 >0 Else Your output needs to have Customer ID and Cluster only