cash_holdings.sql

WITH 

sics AS (
    SELECT DISTINCT gvkey, sic::integer
    FROM comp.company),

obs AS (
    SELECT gvkey, datadate, fyear, COALESCE(sich, sic) AS sic, fic
    FROM comp.funda
    INNER JOIN sics
    USING (gvkey)
    WHERE indfmt='INDL' AND consol='C' AND popsrc='D' AND datafmt='STD'
        AND at > 0 AND sale > 0 AND fic='USA')

SELECT fyear, count(*)
FROM obs
WHERE sic NOT BETWEEN 6000 AND 6999 AND sic NOT BETWEEN 4900 AND 4999 AND sic IS NOT NULL
GROUP BY 1
ORDER BY 1;