Untitled

From Soft Lion, 4 Months ago, written in Plain Text, viewed 52 times.

URL http://codebin.org/view/f1726239 Embed

Download Paste or View Raw

WITH
 
t1 AS (SELECT funding_round_id, company_id, fund_id
       FROM investment),
 
t2 AS (SELECT id, funded_at
       FROM funding_round
       WHERE EXTRACT(YEAR FROM funded_at) BETWEEN 2010 AND 2013
       ),
 
t3 AS (SELECT acquired_company_id, price_amount
       FROM acquisition
       WHERE EXTRACT(YEAR FROM acquired_at) BETWEEN 2010 AND 2013
      )
 
 
SELECT EXTRACT(MONTH FROM t2.funded_at),
       COUNT(DISTINCT fund.id) as f_count,
       COUNT(t3.acquired_company_id) as a_count,
       SUM(t3.price_amount) as p_sum
FROM t1
JOIN t2 ON t1.funding_round_id = t2.id
JOIN t3 ON t1.company_id = t3.acquired_company_id
JOIN fund ON t1.fund_id = fund.id
WHERE fund.country_code = 'USA'
GROUP BY EXTRACT(MONTH FROM t2.funded_at)

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?