Re: Untitled

From Mammoth Eider, 4 Months ago, written in Plain Text, viewed 67 times. This paste is a reply to Untitled from Crimson Treeshrew - view diff

URL http://codebin.org/view/35f3ce28 Embed

Download Paste or View Raw

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

Reply to "Re: 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?