Advertisement
Shayrma

Untitled

Dec 12th, 2022
29
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. WITH comp AS
  2.   (SELECT id AS company_id,
  3.           NAME AS company_name
  4.    FROM company
  5.    WHERE milestones>6),
  6.      rounds AS
  7.   (SELECT id,
  8.           company_id,
  9.           raised_amount
  10.    FROM funding_round
  11.    WHERE EXTRACT(YEAR
  12.                  FROM funded_at) BETWEEN 2012 AND 2013)
  13. SELECT f.NAME AS name_of_fund,
  14.        comp.company_name AS name_of_company,
  15.        rounds.raised_amount AS amount
  16. FROM investment AS i
  17. JOIN comp ON i.company_id = comp.company_id
  18. JOIN fund AS f ON f.id = i.fund_id
  19. JOIN rounds ON rounds.id = i.funding_round_id
  20.  
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement