Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT c.name
- , EXTRACT(MONTH FROM CAST(frr.funded_at AS date)) AS month
- FROM company AS c
- LEFT JOIN funding_round AS frr ON c.id=frr.company_id
- WHERE category_code='social' AND c.id IN (
- SELECT fr.company_id
- FROM funding_round AS fr
- WHERE EXTRACT(YEAR FROM CAST(fr.funded_at AS date)) BETWEEN 2010 AND 2013
- AND fr.raised_amount > 0
- )
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement