Advertisement
valeksan

21

Nov 26th, 2023
212
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. SELECT c.name
  2.         , EXTRACT(MONTH FROM CAST(frr.funded_at AS date)) AS month
  3. FROM company AS c
  4. LEFT JOIN funding_round AS frr ON c.id=frr.company_id
  5. WHERE category_code='social' AND c.id IN (
  6.     SELECT i.company_id
  7.     FROM investment AS i
  8.     INNER JOIN funding_round AS fr ON i.funding_round_id=fr.id
  9.     WHERE EXTRACT(YEAR FROM CAST(fr.funded_at AS date)) BETWEEN 2010 AND 2013
  10.         AND fr.raised_amount > 0
  11. )
  12.  
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement