Untitled

 avatar
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...