Untitled

From Alex, 4 Months ago, written in Plain Text, viewed 49 times. This paste will check out in 1 Second.

URL http://codebin.org/view/7abb683e Embed

Download Paste or View Raw

SELECT f.name AS fund_name,
       c.name AS company_name,
       frq.raised_amount AS attracted_investment
FROM investment as i
LEFT JOIN company AS c ON i.company_id=c.id
LEFT JOIN fund AS f ON i.fund_id=f.id
INNER JOIN (SELECT *
            FROM funding_round
            WHERE EXTRACT(YEAR from funded_at) IN ('2012','2013')
           ) AS frq ON i.company_id=frq.company_id
WHERE c.milestones >6

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?