PRAGMA foreign_keys = ON;

PRAGMA writable_schema = 1;
DELETE FROM sqlite_master WHERE type IN ("table", "index", "trigger");
PRAGMA writable_schema = 0;
VACUUM;

CREATE TABLE "car_names" (
"MakeId" INT,
"Model" TEXT,
PRIMARY KEY ("MakeId")
);

CREATE TABLE "cars_data" (
"Id" INT,
"MPG" TEXT,
"Cylinders" INT,
"Horsepower" TEXT,
"Weight" INT,
"Year" INT,
PRIMARY KEY ("Id"),
FOREIGN KEY ("Id") REFERENCES "car_names"("MakeId")
);





INSERT INTO "car_names" VALUES ("1", "chevrolet chevelle malibu");
INSERT INTO "car_names" VALUES ("2", "buick skylark 320");
INSERT INTO "car_names" VALUES ("3", "plymouth satellite");
INSERT INTO "car_names" VALUES ("4", "amc rebel sst");
INSERT INTO "car_names" VALUES ("5", "ford torino");
INSERT INTO "car_names" VALUES ("6", "ford galaxie 500");
INSERT INTO "car_names" VALUES ("7", "chevrolet impala");
INSERT INTO "car_names" VALUES ("8", "plymouth fury iii");
INSERT INTO "car_names" VALUES ("9", "pontiac catalina");
INSERT INTO "car_names" VALUES ("10", "amc ambassador dpl");
INSERT INTO "car_names" VALUES ("11", "citroen ds-21 pallas");
INSERT INTO "car_names" VALUES ("12", "chevrolet chevelle concours sw");
INSERT INTO "car_names" VALUES ("13", "ford torino sw");
INSERT INTO "car_names" VALUES ("14", "plymouth satellite sw");
INSERT INTO "car_names" VALUES ("15", "amc rebel sst sw");
INSERT INTO "car_names" VALUES ("16", "dodge challenger se");
INSERT INTO "car_names" VALUES ("17", "plymouth cuda 340");
INSERT INTO "car_names" VALUES ("18", "ford mustang boss 302");
INSERT INTO "car_names" VALUES ("19", "chevrolet monte carlo");
INSERT INTO "car_names" VALUES ("20", "buick estate wagon sw");
INSERT INTO "car_names" VALUES ("21", "toyota corona mark ii");
INSERT INTO "car_names" VALUES ("22", "plymouth duster");
INSERT INTO "car_names" VALUES ("23", "amc hornet");
INSERT INTO "car_names" VALUES ("24", "ford maverick");
INSERT INTO "car_names" VALUES ("25", "datsun pl510");
INSERT INTO "car_names" VALUES ("26", "volkswagen 1131 deluxe sedan");
INSERT INTO "car_names" VALUES ("27", "peugeot 504");
INSERT INTO "car_names" VALUES ("28", "audi 100 ls");
INSERT INTO "car_names" VALUES ("29", "saab 99e");
INSERT INTO "car_names" VALUES ("30", "bmw 2002");
INSERT INTO "car_names" VALUES ("31", "amc gremlin");
INSERT INTO "car_names" VALUES ("32", "ford f250");
INSERT INTO "car_names" VALUES ("33", "chevy c20");
INSERT INTO "car_names" VALUES ("34", "dodge d200");
INSERT INTO "car_names" VALUES ("35", "hi 1200d");
INSERT INTO "car_names" VALUES ("36", "datsun pl510");
INSERT INTO "car_names" VALUES ("37", "chevrolet vega 2300");
INSERT INTO "car_names" VALUES ("38", "toyota corona");
INSERT INTO "car_names" VALUES ("39", "ford pinto");
INSERT INTO "car_names" VALUES ("40", "volkswagen super beetle 117");
INSERT INTO "car_names" VALUES ("41", "amc gremlin");
INSERT INTO "car_names" VALUES ("42", "plymouth satellite custom");
INSERT INTO "car_names" VALUES ("43", "chevrolet chevelle malibu");
INSERT INTO "car_names" VALUES ("44", "ford torino 500");
INSERT INTO "car_names" VALUES ("45", "amc matador");
INSERT INTO "car_names" VALUES ("46", "chevrolet impala");
INSERT INTO "car_names" VALUES ("47", "pontiac catalina brougham");
INSERT INTO "car_names" VALUES ("48", "plymouth fury iii");
INSERT INTO "car_names" VALUES ("49", "dodge monaco sw");
INSERT INTO "car_names" VALUES ("50", "ford country squire sw");
INSERT INTO "car_names" VALUES ("51", "pontiac safari sw");
INSERT INTO "car_names" VALUES ("52", "amc hornet sportabout sw");
INSERT INTO "car_names" VALUES ("53", "chevrolet vega sw");
INSERT INTO "car_names" VALUES ("54", "pontiac firebird");
INSERT INTO "car_names" VALUES ("55", "ford pinto sw");
INSERT INTO "car_names" VALUES ("56", "datsun 1200");
INSERT INTO "car_names" VALUES ("57", "volkswagen model 111");
INSERT INTO "car_names" VALUES ("58", "plymouth cricket");
INSERT INTO "car_names" VALUES ("59", "toyota corona hardtop");
INSERT INTO "car_names" VALUES ("60", "dodge colt hardtop");
INSERT INTO "car_names" VALUES ("61", "volkswagen type 3");
INSERT INTO "car_names" VALUES ("62", "chevrolet vega");
INSERT INTO "car_names" VALUES ("63", "ford pinto runabout");
INSERT INTO "car_names" VALUES ("64", "chevrolet impala");
INSERT INTO "car_names" VALUES ("65", "pontiac catalina");
INSERT INTO "car_names" VALUES ("66", "plymouth fury iii");
INSERT INTO "car_names" VALUES ("67", "ford galaxie 500");
INSERT INTO "car_names" VALUES ("68", "amc ambassador sst");
INSERT INTO "car_names" VALUES ("69", "mercury marquis");
INSERT INTO "car_names" VALUES ("70", "buick lesabre custom");
INSERT INTO "car_names" VALUES ("71", "oldsmobile delta 88 royale");
INSERT INTO "car_names" VALUES ("72", "chrysler new yorker brougham");
INSERT INTO "car_names" VALUES ("73", "datsun 610");
INSERT INTO "car_names" VALUES ("74", "toyota mark ii");
INSERT INTO "car_names" VALUES ("75", "plymouth satellite custom sw");
INSERT INTO "car_names" VALUES ("76", "ford gran torino sw");
INSERT INTO "car_names" VALUES ("77", "chrysler town & country sw");
INSERT INTO "car_names" VALUES ("78", "volkswagen 411 sw");
INSERT INTO "car_names" VALUES ("79", "peugeot 504 sw");
INSERT INTO "car_names" VALUES ("80", "renault 12 sw");
INSERT INTO "car_names" VALUES ("81", "ford pinto sw");
INSERT INTO "car_names" VALUES ("82", "datsun 510 sw");
INSERT INTO "car_names" VALUES ("83", "toyota corona mark ii sw");
INSERT INTO "car_names" VALUES ("84", "dodge colt sw");
INSERT INTO "car_names" VALUES ("85", "toyota corolla 1200");
INSERT INTO "car_names" VALUES ("86", "datsun 1200");
INSERT INTO "car_names" VALUES ("87", "volkswagen super beetle");
INSERT INTO "car_names" VALUES ("88", "ford country");
INSERT INTO "car_names" VALUES ("89", "plymouth custom suburb");
INSERT INTO "car_names" VALUES ("90", "oldsmobile vista cruiser");
INSERT INTO "car_names" VALUES ("91", "amc gremlin");
INSERT INTO "car_names" VALUES ("92", "chevrolet nova");
INSERT INTO "car_names" VALUES ("93", "datsun 620");
INSERT INTO "car_names" VALUES ("94", "fiat 124 sport coupe");
INSERT INTO "car_names" VALUES ("95", "fiat 128");
INSERT INTO "car_names" VALUES ("96", "honda civic");
INSERT INTO "car_names" VALUES ("97", "honda civic cvcc");
INSERT INTO "car_names" VALUES ("98", "dodge colt");
INSERT INTO "car_names" VALUES ("99", "chevrolet vega");
INSERT INTO "car_names" VALUES ("100", "fiat 128");
INSERT INTO "car_names" VALUES ("101", "fiat 124 tc");
INSERT INTO "car_names" VALUES ("102", "fiat x1/9");
INSERT INTO "car_names" VALUES ("103", "plymouth duster");
INSERT INTO "car_names" VALUES ("104", "ford maverick");
INSERT INTO "car_names" VALUES ("105", "amc hornet");
INSERT INTO "car_names" VALUES ("106", "chevrolet nova");
INSERT INTO "car_names" VALUES ("107", "datsun b210");
INSERT INTO "car_names" VALUES ("108", "ford pinto");
INSERT INTO "car_names" VALUES ("109", "volkswagen rabbit");
INSERT INTO "car_names" VALUES ("110", "honda civic");
INSERT INTO "car_names" VALUES ("111", "fiat 128");
INSERT INTO "car_names" VALUES ("112", "fiat 124 tc");
INSERT INTO "car_names" VALUES ("113", "plymouth valiant custom");
INSERT INTO "car_names" VALUES ("114", "chevrolet nova");
INSERT INTO "car_names" VALUES ("115", "ford gran torino");
INSERT INTO "car_names" VALUES ("116", "chrysler new yorker brougham");
INSERT INTO "car_names" VALUES ("117", "buick century luxus sw");
INSERT INTO "car_names" VALUES ("118", "dodge coronet custom sw");
INSERT INTO "car_names" VALUES ("119", "ford gran torino sw");
INSERT INTO "car_names" VALUES ("120", "amc matador sw");
INSERT INTO "car_names" VALUES ("121", "audi fox");
INSERT INTO "car_names" VALUES ("122", "volkswagen dasher");
INSERT INTO "car_names" VALUES ("123", "opel manta");
INSERT INTO "car_names" VALUES ("124", "toyota corona");
INSERT INTO "car_names" VALUES ("125", "datsun 710");
INSERT INTO "car_names" VALUES ("126", "dodge colt");
INSERT INTO "car_names" VALUES ("127", "fiat 128");
INSERT INTO "car_names" VALUES ("128", "fiat 124 tc");
INSERT INTO "car_names" VALUES ("129", "honda civic");
INSERT INTO "car_names" VALUES ("130", "subaru");
INSERT INTO "car_names" VALUES ("131", "volkswagen dasher");
INSERT INTO "car_names" VALUES ("132", "datsun 710");
INSERT INTO "car_names" VALUES ("133", "toyota mark ii");
INSERT INTO "car_names" VALUES ("134", "plymouth valiant");
INSERT INTO "car_names" VALUES ("135", "ford maverick");
INSERT INTO "car_names" VALUES ("136", "amc hornet");
INSERT INTO "car_names" VALUES ("137", "chevrolet nova");
INSERT INTO "car_names" VALUES ("138", "datsun b210");
INSERT INTO "car_names" VALUES ("139", "volkswagen rabbit");
INSERT INTO "car_names" VALUES ("140", "honda civic cvcc");
INSERT INTO "car_names" VALUES ("141", "plymouth arrow");
INSERT INTO "car_names" VALUES ("142", "datsun f-10 hatchback");
INSERT INTO "car_names" VALUES ("143", "volkswagen rabbit custom");
INSERT INTO "car_names" VALUES ("144", "mazda glc");
INSERT INTO "car_names" VALUES ("145", "dodge colt m/m");
INSERT INTO "car_names" VALUES ("146", "plymouth volare custom");
INSERT INTO "car_names" VALUES ("147", "ford granada ghia");
INSERT INTO "car_names" VALUES ("148", "pontiac ventura sj");
INSERT INTO "car_names" VALUES ("149", "amc hornet");
INSERT INTO "car_names" VALUES ("150", "chevrolet nova");
INSERT INTO "car_names" VALUES ("151", "datsun b-210");
INSERT INTO "car_names" VALUES ("152", "opel manta");
INSERT INTO "car_names" VALUES ("153", "audi 100 ls");
INSERT INTO "car_names" VALUES ("154", "peugeot 504");
INSERT INTO "car_names" VALUES ("155", "volvo 244dl");
INSERT INTO "car_names" VALUES ("156", "saab 99e gl");
INSERT INTO "car_names" VALUES ("157", "honda accord cvcc");
INSERT INTO "car_names" VALUES ("158", "fiat 131");
INSERT INTO "car_names" VALUES ("159", "opel manta");
INSERT INTO "car_names" VALUES ("160", "volkswagen rabbit custom diesel");
INSERT INTO "car_names" VALUES ("161", "chrysler lebaron salon");
INSERT INTO "car_names" VALUES ("162", "buick century special");
INSERT INTO "car_names" VALUES ("163", "ford fairmont auto");
INSERT INTO "car_names" VALUES ("164", "ford fairmont man");
INSERT INTO "car_names" VALUES ("165", "plymouth volare");
INSERT INTO "car_names" VALUES ("166", "amc concord");
INSERT INTO "car_names" VALUES ("167", "buick opel isuzu deluxe");
INSERT INTO "car_names" VALUES ("168", "renault 5 gtl");
INSERT INTO "car_names" VALUES ("169", "plymouth horizon omni");
INSERT INTO "car_names" VALUES ("170", "datsun b210 gx");
INSERT INTO "car_names" VALUES ("171", "fiat strada custom");
INSERT INTO "car_names" VALUES ("172", "volkswagen rabbit custom");
INSERT INTO "car_names" VALUES ("173", "mazda glc deluxe");
INSERT INTO "car_names" VALUES ("174", "dodge omni");
INSERT INTO "car_names" VALUES ("175", "toyota celica gt liftback");
INSERT INTO "car_names" VALUES ("176", "plymouth volare premier v8");
INSERT INTO "car_names" VALUES ("177", "ford fairmont futura");
INSERT INTO "car_names" VALUES ("178", "amc concord dl");
INSERT INTO "car_names" VALUES ("179", "dodge aspen");
INSERT INTO "car_names" VALUES ("180", "buick regal sport coupe turbo");
INSERT INTO "car_names" VALUES ("181", "ford futura");
INSERT INTO "car_names" VALUES ("182", "dodge magnum xe");
INSERT INTO "car_names" VALUES ("183", "chevrolet monte carlo landau");
INSERT INTO "car_names" VALUES ("184", "chrysler lebaron salon");
INSERT INTO "car_names" VALUES ("185", "buick century limited");
INSERT INTO "car_names" VALUES ("186", "oldsmobile cutlass salon brougham");
INSERT INTO "car_names" VALUES ("187", "dodge diplomat");
INSERT INTO "car_names" VALUES ("188", "mercury monarch ghia");
INSERT INTO "car_names" VALUES ("189", "pontiac phoenix lj");
INSERT INTO "car_names" VALUES ("190", "chevrolet citation");
INSERT INTO "car_names" VALUES ("191", "oldsmobile omega");
INSERT INTO "car_names" VALUES ("192", "buick skylark");
INSERT INTO "car_names" VALUES ("193", "amc concord");
INSERT INTO "car_names" VALUES ("194", "ford fairmont");
INSERT INTO "car_names" VALUES ("195", "datsun 210");
INSERT INTO "car_names" VALUES ("196", "honda civic 1500 gl");
INSERT INTO "car_names" VALUES ("197", "toyota corolla tercel");
INSERT INTO "car_names" VALUES ("198", "mazda glc");
INSERT INTO "car_names" VALUES ("199", "plymouth horizon");
INSERT INTO "car_names" VALUES ("200", "plymouth horizon tc3");
INSERT INTO "car_names" VALUES ("201", "datsun 280-zx");
INSERT INTO "car_names" VALUES ("202", "mazda rx-7 gs");
INSERT INTO "car_names" VALUES ("203", "plymouth champ");
INSERT INTO "car_names" VALUES ("204", "honda civic 1300");
INSERT INTO "car_names" VALUES ("205", "honda accord gl");
INSERT INTO "car_names" VALUES ("206", "volkswagen rabbit custom");
INSERT INTO "car_names" VALUES ("207", "mazda 626");
INSERT INTO "car_names" VALUES ("208", "datsun 510 hatchback");
INSERT INTO "car_names" VALUES ("209", "toyota corolla liftback");
INSERT INTO "car_names" VALUES ("210", "ford mustang gl");
INSERT INTO "car_names" VALUES ("211", "chevrolet cavalier");
INSERT INTO "car_names" VALUES ("212", "chevrolet cavalier wagon");
INSERT INTO "car_names" VALUES ("213", "chevrolet cavalier 2-door");
INSERT INTO "car_names" VALUES ("214", "pontiac j2000 se hatchback");
INSERT INTO "car_names" VALUES ("215", "dodge aries wagon sw");
INSERT INTO "car_names" VALUES ("216", "plymouth reliant sw");
INSERT INTO "car_names" VALUES ("217", "ford escorts 3000");
INSERT INTO "car_names" VALUES ("218", "mazda glc custom l");
INSERT INTO "car_names" VALUES ("219", "mazda glc custom");
INSERT INTO "car_names" VALUES ("220", "plymouth horizon miser");
INSERT INTO "car_names" VALUES ("221", "mercury lynx l");
INSERT INTO "car_names" VALUES ("222", "nissan stanza xe");
INSERT INTO "car_names" VALUES ("223", "honda accord");
INSERT INTO "car_names" VALUES ("224", "toyota corolla");
INSERT INTO "car_names" VALUES ("225", "honda civic");
INSERT INTO "car_names" VALUES ("226", "honda civic auto");
INSERT INTO "car_names" VALUES ("227", "datsun 310 gx");
INSERT INTO "car_names" VALUES ("228", "buick skylark limited");
INSERT INTO "car_names" VALUES ("229", "chevrolet citation");
INSERT INTO "car_names" VALUES ("230", "oldsmobile omega brougham");
INSERT INTO "car_names" VALUES ("231", "pontiac phoenix");
INSERT INTO "car_names" VALUES ("232", "ford fairmont futura");
INSERT INTO "car_names" VALUES ("233", "amc concord dl");
INSERT INTO "car_names" VALUES ("234", "dodge aries se");
INSERT INTO "car_names" VALUES ("235", "plymouth reliant");
INSERT INTO "car_names" VALUES ("236", "toyota starlet");
INSERT INTO "car_names" VALUES ("237", "plymouth champ");
INSERT INTO "car_names" VALUES ("238", "honda civic 1300");
INSERT INTO "car_names" VALUES ("239", "subaru dl");
INSERT INTO "car_names" VALUES ("240", "volkswagen rabbit");
INSERT INTO "car_names" VALUES ("241", "datsun 210 mpg");
INSERT INTO "car_names" VALUES ("242", "mazda glc");
INSERT INTO "car_names" VALUES ("243", "dodge colt hatchback custom");
INSERT INTO "car_names" VALUES ("244", "ford escort 4w");
INSERT INTO "car_names" VALUES ("245", "volkswagen jetta");
INSERT INTO "car_names" VALUES ("246", "nissan stanza xe");
INSERT INTO "car_names" VALUES ("247", "honda accord");
INSERT INTO "car_names" VALUES ("248", "toyota corolla");
INSERT INTO "car_names" VALUES ("249", "datsun 200sx");
INSERT INTO "car_names" VALUES ("250", "mazda 626");
INSERT INTO "car_names" VALUES ("251", "peugeot 604sl");
INSERT INTO "car_names" VALUES ("252", "bmw 320i");
INSERT INTO "car_names" VALUES ("253", "volkswagen rabbit l");
INSERT INTO "car_names" VALUES ("254", "oldsmobile cutlass ciera diesel");
INSERT INTO "car_names" VALUES ("255", "chrysler new yorker fifth avenue");
INSERT INTO "car_names" VALUES ("256", "dodge diplomat custom");
INSERT INTO "car_names" VALUES ("257", "buick century limited");
INSERT INTO "car_names" VALUES ("258", "cadillac cimarron");
INSERT INTO "car_names" VALUES ("259", "ford granada l");
INSERT INTO "car_names" VALUES ("260", "toyota celica gt");
INSERT INTO "car_names" VALUES ("261", "dodge charger 2.2");
INSERT INTO "car_names" VALUES ("262", "chevrolet camaro");
INSERT INTO "car_names" VALUES ("263", "ford mustang");
INSERT INTO "car_names" VALUES ("264", "chrysler new yorker brougham");
INSERT INTO "car_names" VALUES ("265", "dodge aries se");
INSERT INTO "car_names" VALUES ("266", "plymouth reliant custom");
INSERT INTO "car_names" VALUES ("267", "ford escort l");
INSERT INTO "car_names" VALUES ("268", "toyota corolla");
INSERT INTO "car_names" VALUES ("269", "honda civic custom");
INSERT INTO "car_names" VALUES ("270", "honda accord gl");
INSERT INTO "car_names" VALUES ("271", "mazda glc custom");
INSERT INTO "car_names" VALUES ("272", "chevrolet cavalier wagon");
INSERT INTO "car_names" VALUES ("273", "ford ltd");
INSERT INTO "car_names" VALUES ("274", "buick lesabre custom coupe");
INSERT INTO "car_names" VALUES ("275", "oldsmobile cutlass ciera diesel");
INSERT INTO "car_names" VALUES ("276", "chrysler new yorker brougham");
INSERT INTO "car_names" VALUES ("277", "dodge aries se");
INSERT INTO "car_names" VALUES ("278", "plymouth reliant custom");
INSERT INTO "car_names" VALUES ("279", "ford escort l");
INSERT INTO "car_names" VALUES ("280", "toyota corolla");
INSERT INTO "car_names" VALUES ("281", "honda civic custom");
INSERT INTO "car_names" VALUES ("282", "honda accord gl");
INSERT INTO "car_names" VALUES ("283", "mazda glc custom");
INSERT INTO "car_names" VALUES ("284", "chevrolet cavalier wagon");
INSERT INTO "car_names" VALUES ("285", "ford ltd");
INSERT INTO "car_names" VALUES ("286", "buick lesabre custom coupe");
INSERT INTO "car_names" VALUES ("287", "oldsmobile cutlass ciera diesel");
INSERT INTO "car_names" VALUES ("288", "chrysler new yorker brougham");
INSERT INTO "car_names" VALUES ("289", "dodge aries se");
INSERT INTO "car_names" VALUES ("290", "plymouth reliant custom");
INSERT INTO "car_names" VALUES ("291", "ford escort l");
INSERT INTO "car_names" VALUES ("292", "toyota corolla");
INSERT INTO "car_names" VALUES ("293", "honda civic custom");
INSERT INTO "car_names" VALUES ("294", "honda accord gl");
INSERT INTO "car_names" VALUES ("295", "mazda glc custom");
INSERT INTO "car_names" VALUES ("296", "chevrolet cavalier wagon");
INSERT INTO "car_names" VALUES ("297", "ford ltd");
INSERT INTO "car_names" VALUES ("298", "buick lesabre custom coupe");
INSERT INTO "car_names" VALUES ("299", "oldsmobile cutlass ciera diesel");
INSERT INTO "car_names" VALUES ("300", "chrysler new yorker brougham");
INSERT INTO "car_names" VALUES ("301", "dodge aries se");
INSERT INTO "car_names" VALUES ("302", "plymouth reliant custom");
INSERT INTO "car_names" VALUES ("303", "ford escort l");
INSERT INTO "car_names" VALUES ("304", "toyota corolla");