Untitled

From Gruff Marten, 4 Months ago, written in SQL, viewed 53 times.

URL http://codebin.org/view/654ebc97 Embed

Download Paste or View Raw

WITH 
c AS
     (SELECT milestones,
              id, name AS name_of_company
      FROM company
      WHERE milestones > 6
     )
 
SELECT f.name AS name_of_fund, c.name_of_company, SUM(fr.raised_amount) AS amount
FROM investment AS i
 
JOIN c ON i.company_id = c.id
JOIN fund AS f ON i.fund_id = f.id
JOIN funding_round AS fr ON i.funding_round_id = fr.id
 
WHERE EXTRACT(YEAR FROM fr.funded_at) IN (2012, 2013)
GROUP BY f.name, c.name_of_company

Reply to "Untitled"

Here you can reply to the paste above

Author What's your name?

Title Give your paste a title.

Language What language is your paste written in?

Your paste Paste your paste here

Create Shorturl Create a shorter url that redirects to your paste?

Private Private paste aren't shown in recent listings.

Delete After When should we delete your paste?