GeorgiaLargest15TableCollectionSQlScript.sql

CREATE TABLE GeorgiaLargest15 (
    `Name` VARCHAR(34) CHARACTER SET utf8,
    `City` VARCHAR(13) CHARACTER SET utf8,
    `State` VARCHAR(2) CHARACTER SET utf8,
    `Size` INT,
    `Amer_Indian` NUMERIC(2, 1),
    `African_Amer` NUMERIC(3, 1),
    `Asian_Pac_Is` NUMERIC(3, 1),
    `Hispanic` NUMERIC(3, 1),
    `International` NUMERIC(3, 1),
    `White` NUMERIC(3, 1),
    `multi_race_not_hispanic_latino` NUMERIC(2, 1),
    `Unknown` NUMERIC(2, 1),
    `Women` NUMERIC(3, 1),
    `Men` NUMERIC(3, 1)
);
INSERT INTO GeorgiaLargest15 VALUES ('Kennesaw State University','Kennesaw','GA',30480,0.2,20.7,4.5,8.7,1.7,59.2,4.4,2.3,48.9,51.1);
INSERT INTO GeorgiaLargest15 VALUES ('University of Georgia','Athens','GA',27547,0.1,7.6,9.8,5.5,1.6,72.4,3.8,0.8,56.9,43.1);
INSERT INTO GeorgiaLargest15 VALUES ('Georgia State University','Atlanta','GA',25160,0.2,42.8,12.6,9.9,1.8,26.8,5.1,2.7,59,41);
INSERT INTO GeorgiaLargest15 VALUES ('Georgia Southern University','Statesboro','GA',17963,0.5,26.7,1.7,4.9,1.4,63.3,1.9,1,50.2,49.8);
INSERT INTO GeorgiaLargest15 VALUES ('University of North Georgia','Dahlonega','GA',16729,0.2,4.2,2.9,10.6,1.6,78.1,2.7,1.4,55.2,44.8);
INSERT INTO GeorgiaLargest15 VALUES ('Georgia Insitute of Technology','Atlanta','GA',14884,0.1,7.5,21.5,7.4,10.6,56.9,4.1,2.6,34.3,65.7);
INSERT INTO GeorgiaLargest15 VALUES ('Georgia Gwinnet College','Lawrenceville','GA',11468,0.1,33.7,9.9,16.7,1.8,35,3.8,0.7,56.2,43.8);
INSERT INTO GeorgiaLargest15 VALUES ('University of West Georgia','Carrollton','GA',10753,0.1,37.2,1.1,4.8,1.1,50.6,3.3,2.9,63.2,36.8);
INSERT INTO GeorgiaLargest15 VALUES ('Savannah College of Art and Design','Savannah','GA',10185,0.6,13,10.3,9.9,16.7,61.3,0,5,65.8,34.2);
INSERT INTO GeorgiaLargest15 VALUES ('Valdosta State University','Valdosta','GA',8796,0.3,37.2,1.4,5.1,2.8,51.8,3.3,0.8,59.1,40.9);
INSERT INTO GeorgiaLargest15 VALUES ('Columbus State University','Colombus','GA',6937,0.3,37,2.5,5.6,1.1,52.4,2.1,0,60.2,39.8);
INSERT INTO GeorgiaLargest15 VALUES ('Emory University','Atlanta','GA',6867,0.2,11.1,22.9,9.7,16.7,48.7,3.6,3.8,58.1,41.9);
INSERT INTO GeorgiaLargest15 VALUES ('Clayton State University','Morrow','GA',6587,0.2,63.2,5.3,3.3,1.1,21.6,2.7,3.6,68.4,31.6);
INSERT INTO GeorgiaLargest15 VALUES ('Armstrong State University','Savannah','GA',6331,0.2,25.2,3.5,7.2,1.6,57.9,4.7,1,66.4,33.6);