220
edits
Changes
Jump to navigation
Jump to search
→Cleaning fundbase
CREATE TABLE fundbase1 AS
SELECT *, CASE
WHEN fundname LIKE '%Undisclosed FirmFund%' THEN 1::int
ELSE 0::int END AS undisclosedflag
FROM fundbase;
--27588
SELECT COUNT(*) FROM (SELECT DISTINCT fundname, closedate, firstinvdate FROM fundbase1 WHERE undisclosedflag = 0)a; --2757127097
==Cleaning roundline==
