Changes

Competition - We need to determine how many other competitors (in the same industry, given by first 3 digits of NAICS code) the acquirer had in the year of the acquisition. To do so, create a table with 3 digit naics codes, naics codes, the year, and the count of the naics codes in the year minus one then group by naics and year from crspfinal. Then join back to main table on naics code.