Changes
Jump to navigation
Jump to search
→The Research
FROM ManwomanCompany2
LEFT JOIN titles01 ON manwomancompany2.jobtitle=titles01.title;
==tables for percent of women in a given job title==
DROP TABLE PercentWomenCompany;
CREATE TABLE PercentWomenCompany AS
SELECT sum(mf)/count(mf) FROM ManWomanCompany3;
--.29812
DROP TABLE PercentWomenCEOsCompany;
CREATE TABLE PercentWomenCEOsCompany AS
SELECT sum(mf)/count(mf) FROM ManWomanCompany3 WHERE ceo = 1;
--.22597
DROP TABLE PercentWomenChairmanCompany;
CREATE TABLE PercentWomenChairmanCompany AS
SELECT sum(mf)/count(mf) FROM ManWomanCompany3 WHERE chairman = 1;
--.142417
DROP TABLE PercentWomenCFOCompany;
CREATE TABLE PercentWomenCFOCompany AS
SELECT sum(mf)/count(mf) FROM ManWomanCompany3 WHERE cfo = 1;
--.27087
DROP TABLE PercentWomenCOOCompany;
CREATE TABLE PercentWomenCOOCompany AS
SELECT sum(mf)/count(mf) FROM ManWomanCompany3 WHERE coo = 1;
--.26353
DROP TABLE PercentWomenCIOCompany;
CREATE TABLE PercentWomenCIOCompany AS
SELECT sum(mf)/count(mf) FROM ManWomanCompany3 WHERE cio = 1;
--.31707
DROP TABLE PercentWomenCTOCompany;
CREATE TABLE PercentWomenCTOCompany AS
SELECT sum(mf)/count(mf) FROM ManWomanCompany3 WHERE cto = 1;
--.12588
DROP TABLE PercentWomenboardmemberCompany;
CREATE TABLE PercentWomenboardmemberCompany AS
SELECT sum(mf)/count(mf) FROM ManWomanCompany3 WHERE boardmember = 1;
--.2545
DROP TABLE PercentWomenPresidentCompany;
CREATE TABLE PercentWomenPresidentCompany AS
SELECT sum(mf)/count(mf) FROM ManWomanCompany3 WHERE president = 1;
--.19646
DROP TABLE PercentWomenVPCompany;
CREATE TABLE PercentWomenVPCompany AS
SELECT sum(mf)/count(mf) FROM ManWomanCompany3 WHERE vicepresident = 1;
--.3468
DROP TABLE PercentWomenfounderCompany;
CREATE TABLE PercentWomenfounderCompany AS
SELECT sum(mf)/count(mf) FROM ManWomanCompany3 WHERE founder = 1;
--.2394
DROP TABLE PercentWomendirectorCompany;
CREATE TABLE PercentWomendirectorCompany AS
SELECT sum(mf)/count(mf) FROM ManWomanCompany3 WHERE director = 1;
--.38625
==table for finding percentage of women in companies by state==
DROP TABLE womenstates;
CREATE TABLE womenstates AS
SELECT companystate, sum(mf)/count(mf) FROM ManWomanCompany3 GROUP BY companystate;
==Example output data==
#this data still discounts a (small) percentage of data (doctors who didn't have a common name)
#have data organized, now we need to figure out how to extract it in meaningful terms for the report.
=The Paper=
