WITH
fund_usa AS (SELECT DISTINCT f.id,
                    f.name
            FROM fund AS f
            WHERE f.country_code = 'USA'),

funding AS (SELECT fr.id,
                   EXTRACT(MONTH FROM fr.funded_at) AS month
           FROM funding_round AS fr
           WHERE EXTRACT(YEAR FROM fr.funded_at) BETWEEN '2010' AND '2013')

SELECT funding.month,
       COUNT(DISTINCT fund_usa) AS fund_name,
       COUNT(a.id),
       SUM(a.price_amount)
FROM investment AS i
INNER JOIN funding ON i.funding_round_id = funding.id
INNER JOIN fund_usa ON i.fund_id = fund_usa.id
LEFT OUTER JOIN company AS c ON c.id = i.company_id
INNER JOIN acquisition AS a ON c.id = a.acquired_company_id
GROUP BY funding.month;