New Hire Statistics

CREATE TABLE new_hire_demographics_18 (
  "fiscal_year" BIGINT,
  "total_new_hires" BIGINT,
  "white" BIGINT,
  "n__white" VARCHAR  -- % White,
  "american_indian" BIGINT,
  "n__american_indian" VARCHAR  -- % American Indian,
  "asian" BIGINT,
  "n__asian" VARCHAR  -- % Asian,
  "black_african_american" BIGINT,
  "n__black_african_american" VARCHAR  -- % Black/African American,
  "hispanic" BIGINT,
  "n__hispanic" VARCHAR  -- % Hispanic,
  "pacific_islander" BIGINT,
  "n__pacific_islander" VARCHAR  -- % Pacific Islander,
  "not_specified" BIGINT,
  "n__not_specified" VARCHAR  -- % Not Specified,
  "female" BIGINT,
  "n__female" VARCHAR  -- % Female,
  "male" BIGINT,
  "n__male" VARCHAR  -- % Male,
  "officials_administrators" BIGINT  -- Officials & Administrators,
  "n__officials_administrators" VARCHAR  -- % Officials & Administrators,
  "professionals" BIGINT,
  "n__professionals" VARCHAR  -- % Professionals,
  "technicians" BIGINT,
  "n__technicians" VARCHAR  -- % Technicians,
  "protective_service_workers" BIGINT,
  "n__protective_service_workers" VARCHAR  -- % Protective Service Workers,
  "paraprofessionals" BIGINT,
  "n__paraprofessionals" VARCHAR  -- % Paraprofessionals,
  "officials_clerical" BIGINT,
  "n__officials_clerical" VARCHAR  -- % Officials-Clerical,
  "skilled_craft" BIGINT,
  "n__skilled_craft" VARCHAR  -- % Skilled Craft,
  "service_maintenance" BIGINT,
  "n__service_maintenance" VARCHAR  -- % Service/Maintenance,
  "classified" BIGINT,
  "n__classified" VARCHAR  -- % Classified,
  "unclassified" BIGINT,
  "n__unclassified" VARCHAR  -- % Unclassified,
  "traditionalists" BIGINT,
  "n__traditionalists" VARCHAR  -- % Traditionalists,
  "baby_boomers" BIGINT,
  "n__baby_boomers" VARCHAR  -- % Baby Boomers,
  "gen_x" BIGINT,
  "n__gen_x" VARCHAR  -- % Gen X,
  "millennials" BIGINT,
  "n__millennials" VARCHAR  -- % Millennials
);