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