Untitled
unknown
pgsql
2 years ago
697 B
21
Indexable
/* WITH fin_10_13 AS (SELECT company_id, -- ID of COMP with fin. 2010-2013 EXTRACT(MONTH FROM funded_at) AS month FROM funding_round WHERE EXTRACT(YEAR FROM funded_at) BETWEEN 2010 AND 2013) SELECT comp.name AS name, fin_10_13.month AS month FROM company AS comp LEFT JOIN fin_10_13 ON comp.id = fin_10_13.company_id WHERE category_code = 'social' AND funding_total > 0 */ SELECT comp.name AS name, EXTRACT(MONTH FROM funded_at) AS month FROM company AS comp JOIN funding_round AS fr ON comp.id = fr.company_id WHERE EXTRACT(YEAR FROM funded_at) BETWEEN 2010 AND 2013 AND comp.category_code = 'social' AND funding_total > 0
Editor is loading...