WITH

month_round AS (SELECT EXTRACT(MONTH FROM fr.funded_at) AS month,
                       COUNT(a.id) AS count_company,
                       SUM(a.price_amount) AS sum_price
               FROM investment AS i
               LEFT OUTER JOIN funding_round AS fr ON i.funding_round_id = fr.id
               LEFT OUTER JOIN company AS c ON fr.company_id = c.id
               RIGHT OUTER JOIN acquisition AS a ON c.id = a.acquiring_company_id
               WHERE EXTRACT(YEAR FROM fr.funded_at) BETWEEN '2010' AND '2013'
               GROUP BY EXTRACT(MONTH FROM fr.funded_at)),

fund_usa AS (SELECT EXTRACT(MONTH FROM fr.funded_at) AS month,
                    COUNT(DISTINCT f.name) AS usa_name
             FROM investment AS i
             LEFT OUTER JOIN funding_round AS fr ON i.funding_round_id = fr.id
             LEFT OUTER JOIN fund AS f ON i.fund_id = f.id
             WHERE EXTRACT(YEAR FROM fr.funded_at) BETWEEN '2010' AND '2013'
               AND f.country_code = 'USA'
             GROUP BY EXTRACT(MONTH FROM fr.funded_at))

SELECT month_round.month,
       fund_usa.usa_name,
       month_round.count_company,
       month_round.sum_price
FROM month_round
INNER JOIN fund_usa ON month_round.month = fund_usa.month;