Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- WITH comp AS
- (SELECT id AS company_id,
- NAME AS company_name
- FROM company
- WHERE milestones>6),
- rounds AS
- (SELECT id,
- company_id,
- raised_amount
- FROM funding_round
- WHERE EXTRACT(YEAR
- FROM funded_at) BETWEEN 2012 AND 2013)
- SELECT f.NAME AS name_of_fund,
- comp.company_name AS name_of_company,
- rounds.raised_amount AS amount
- FROM investment AS i
- JOIN comp ON i.company_id = comp.company_id
- JOIN fund AS f ON f.id = i.fund_id
- JOIN rounds ON rounds.id = i.funding_round_id
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement