solution

The Standard Industrial Classification (SIC) is a North American Industry Classification System (NAICS), for classifying industries by a four-digit code. The first two digits of the code identify the major industry group, the third digit identifies the industry group, and the fourth digit identifies the industry. For example:

54 FOOD STORES

541 GROCERY STORES

5411 GROCERY STORES

5412 Convenience Stores

542 MEAT AND FISH (SEAFOOD) MARKETS, INCLUDING FREEZER PROVISIONERS

5421 MEAT AND FISH (SEAFOOD) MARKETS, INCLUDING FREEZER PROVISIONERS

543 FRUIT AND VEGETABLE MARKETS

5431 FRUIT AND VEGETABLE MARKETS

544 CANDY, NUT, AND CONFECTIONERY STORES

5441 CANDY, NUT, AND CONFECTIONERY STORES

545 DAIRY PRODUCTS STORES

5451 DAIRY PRODUCTS STORES

546 RETAIL BAKERIES

5461 RETAIL BAKERIES

549 MISCELLANEOUS FOOD STORES

5499 MISCELLANEOUS FOOD STORES

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).