Skip to content

Instantly share code, notes, and snippets.

@spara
Created February 6, 2012 19:52
Show Gist options
  • Select an option

  • Save spara/1754394 to your computer and use it in GitHub Desktop.

Select an option

Save spara/1754394 to your computer and use it in GitHub Desktop.
campus dropout rate sql
CREATE TABLE CAMPUS_DROPOUT_RATE(
"CAMP_SPER" numeric,
"CAMP_OVRR" numeric,
"CAMP_MIGR" numeric,
"CAMP_LEPR" numeric,
"CAMP_IMMR" numeric,
"CAMP_GFTR" numeric,
"CAMP_ECNR" numeric,
"CAMP_CTER" numeric,
"CAMP_TTLR" numeric,
"CAMP_BER" numeric,
"CAMP_ATRR" numeric,
"CAMP_MUR" numeric,
"CAMP_PIR" numeric,
"CAMP_WHR" numeric,
"CAMP_NAR" numeric,
"CAMP_HSR" numeric,
"CAMP_ASR" numeric,
"CAMP_AAR" numeric,
"CAMP_FEMR" numeric,
"CAMP_MALR" numeric,
"CAMP_ALLR" numeric,
"DISTRICT" varchar,
"Gradespan" varchar,
"campus" varchar,
"cntyname" varchar,
"regnname" varchar,
"campname" varchar,
"distname" varchar,
"COUNTY" varchar,
"REGION" varchar,
"SCHOOL_YEAR" varchar);
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment