Table: asset_acquisition_details
Columns: asset_acquired
acquired_from
date_announced
date_completed
reported_cost

Question: It was announced on July 2, 2006 that what asset was acquired? 
SQL: SELECT "asset_acquired" FROM asset_acquisition_details WHERE "date_announced" = 'July 2, 2006'

Question: On what date was it announced that an asset was acquired for US$9 Million? 
SQL: SELECT "date_announced" FROM asset_acquisition_details WHERE "reported_cost" = 'US$9 million'

Question: On what date was the asset acquisition that was announced on February 22, 2007 completed?  
SQL: SELECT "date_completed" FROM asset_acquisition_details WHERE "date_announced" = 'February 22, 2007'

Question: It is was announced on July 2, 2006 that what asset had been acquired? 
SQL: SELECT "asset_acquired" FROM asset_acquisition_details WHERE "date_announced" = 'July 2, 2006'

Question: What was the reported cost of the asset acquired from Standard & Poor's? 
SQL: SELECT "reported_cost" FROM asset_acquisition_details WHERE "acquired_from" = 'Standard & Poor''s'