Picking acq_cusip.
Create a table with unique cusip (only first 6 digits) and announcement date values.
SELECT LEFT(acq_cusip, 6) AS acq_cusip, date_announced INTO cusip_announcedate FROM sdc GROUP BY acq_cusip, date_announced;
SELECT 49766
==Previous Papers==