Advertisement
valeksan

21_

Nov 26th, 2023
209
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 fr.company_id
  7.     FROM funding_round AS fr
  8.     WHERE EXTRACT(YEAR FROM CAST(fr.funded_at AS date)) BETWEEN 2010 AND 2013
  9.         AND fr.raised_amount > 0
  10. )
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement