- SELECT f.name AS name_of_fund,
- c.name AS name_of_company,
- fr.raised_amount AS amount
- FROM fund AS f
- LEFT JOIN investment AS i ON f.id = i.fund_id
- LEFT JOIN funding_round AS fr ON i.funding_round_id = fr.id
- LEFT JOIN company AS c ON fr.company_id = c.id
- WHERE c.name IN
- (SELECT c.name AS name_of_company
- FROM company AS c
- LEFT JOIN funding_round AS fr ON c.id = fr.company_id
- WHERE c.milestones > 6
- AND EXTRACT(YEAR FROM CAST(fr.funded_at as date)) BETWEEN 2012 AND 2013);