7,649
edits
Changes
Jump to navigation
Jump to search
Women in Entrepreneurship (Issue Brief) (view source)
Revision as of 15:07, 3 March 2017
, 15:07, 3 March 2017→Spring 2017
Ed is going to add IPO and Acq to Uniquevalstate
Here's the code to add zeros to cleanpeople:
DROP TABLE cleanpeople2;
CREATE TABLE cleanpeople2 AS
SELECT
prefix,
firstname,
lastname,
jobtitle,
fulltitle,
cname,
CASE WHEN genval IS NOT NULL THEN genval ELSE 0::int END AS women,
CASE WHEN doctor IS NOT NULL THEN doctor ELSE 0::int END AS doctor,
CASE WHEN charman IS NOT NULL THEN charman ELSE 0::int END AS charman,
CASE WHEN ceo IS NOT NULL THEN ceo ELSE 0::int END AS ceo,
CASE WHEN cfo IS NOT NULL THEN cfo ELSE 0::int END AS cfo,
CASE WHEN coo IS NOT NULL THEN coo ELSE 0::int END AS coo,
CASE WHEN cio IS NOT NULL THEN cio ELSE 0::int END AS cio,
CASE WHEN cto IS NOT NULL THEN cto ELSE 0::int END AS cto,
CASE WHEN otherclvl IS NOT NULL THEN otherclvl ELSE 0::int END AS otherclvl,
CASE WHEN boardmember IS NOT NULL THEN boardmember ELSE 0::int END AS boardmember,
CASE WHEN president IS NOT NULL THEN president ELSE 0::int END AS president,
CASE WHEN vp IS NOT NULL THEN vp ELSE 0::int END AS vp,
CASE WHEN founder IS NOT NULL THEN founder ELSE 0::int END AS founder,
CASE WHEN director IS NOT NULL THEN director ELSE 0::int END AS director
FROM cleanpeople WHERE jobtitle IS NOT NULL;
==TO DO up to 2/28==
