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,
"Edispl" FLOAT,
"Horsepower" TEXT,
"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 sportabout sw");
INSERT INTO "car_names" VALUES ("24", "chevrolet vega sw");
INSERT INTO "car_names" VALUES ("25", "ford pinto sw");
INSERT INTO "car_names" VALUES ("26", "volkswagen type 3");
INSERT INTO "car_names" VALUES ("27", "volkswagen 411 sw");
INSERT INTO "car_names" VALUES ("28", "peugeot 504 sw");
INSERT INTO "car_names" VALUES ("29", "audi 100 ls");
INSERT INTO "car_names" VALUES ("30", "saab 99e");
INSERT INTO "car_names" VALUES ("31", "bmw 2002 ti");
INSERT INTO "car_names" VALUES ("32", "amc gremlin");
INSERT INTO "car_names" VALUES ("33", "plymouth satellite custom");
INSERT INTO "car_names" VALUES ("34", "chevrolet chevelle malibu");
INSERT INTO "car_names" VALUES ("35", "ford torino 500");
INSERT INTO "car_names" VALUES ("36", "amc matador");
INSERT INTO "car_names" VALUES ("37", "chevrolet impala");
INSERT INTO "car_names" VALUES ("38", "pontiac catalina brougham");
INSERT INTO "car_names" VALUES ("39", "ford galaxie 500");
INSERT INTO "car_names" VALUES ("40", "plymouth fury iii");
INSERT INTO "car_names" VALUES ("41", "dodge monaco sw");
INSERT INTO "car_names" VALUES ("42", "ford country squire sw");
INSERT INTO "car_names" VALUES ("43", "pontiac safari sw");
INSERT INTO "car_names" VALUES ("44", "amc ambassador sst sw");
INSERT INTO "car_names" VALUES ("45", "mercury marquis sw");
INSERT INTO "car_names" VALUES ("46", "buick lesabre custom");
INSERT INTO "car_names" VALUES ("47", "oldsmobile delta 88 royale");
INSERT INTO "car_names" VALUES ("48", "chrysler new yorker brougham");
INSERT INTO "car_names" VALUES ("49", "dodge coronet custom");
INSERT INTO "car_names" VALUES ("50", "ford maverick");
INSERT INTO "car_names" VALUES ("51", "amc gremlin");
INSERT INTO "car_names" VALUES ("52", "fiat 124 sport coupe");
INSERT INTO "car_names" VALUES ("53", "fiat 128");
INSERT INTO "car_names" VALUES ("54", "honda civic");
INSERT INTO "car_names" VALUES ("55", "toyota corona");
INSERT INTO "car_names" VALUES ("56", "datsun 510");
INSERT INTO "car_names" VALUES ("57", "volkswagen super beetle");
INSERT INTO "car_names" VALUES ("58", "plymouth cricket");
INSERT INTO "car_names" VALUES ("59", "toyota corona hardtop sw");
INSERT INTO "car_names" VALUES ("60", "dodge colt sw");
INSERT INTO "car_names" VALUES ("61", "volkswagen type 3 sw");
INSERT INTO "car_names" VALUES ("62", "chevrolet vega");
INSERT INTO "car_names" VALUES ("63", "ford pinto");
INSERT INTO "car_names" VALUES ("64", "datsun 610");
INSERT INTO "car_names" VALUES ("65", "mazda rx2 coupe");
INSERT INTO "car_names" VALUES ("66", "amc matador sw");
INSERT INTO "car_names" VALUES ("67", "chevrolet impala");
INSERT INTO "car_names" VALUES ("68", "pontiac grand prix");
INSERT INTO "car_names" VALUES ("69", "fiat 124 tc");
INSERT INTO "car_names" VALUES ("70", "fiat x1-9");
INSERT INTO "car_names" VALUES ("71", "plymouth valiant");
INSERT INTO "car_names" VALUES ("72", "chevrolet nova custom");
INSERT INTO "car_names" VALUES ("73", "datsun b210");
INSERT INTO "car_names" VALUES ("74", "ford pinto runabout");
INSERT INTO "car_names" VALUES ("75", "chevrolet vega");
INSERT INTO "car_names" VALUES ("76", "plymouth duster");
INSERT INTO "car_names" VALUES ("77", "volkswagen dasher");
INSERT INTO "car_names" VALUES ("78", "datsun 710");
INSERT INTO "car_names" VALUES ("79", "opel manta");
INSERT INTO "car_names" VALUES ("80", "audi 100ls");
INSERT INTO "car_names" VALUES ("81", "peugeot 504");
INSERT INTO "car_names" VALUES ("82", "renault 12tl");
INSERT INTO "car_names" VALUES ("83", "volkswagen rabbit");
INSERT INTO "car_names" VALUES ("84", "datsun b210");
INSERT INTO "car_names" VALUES ("85", "toyota corolla 1200");
INSERT INTO "car_names" VALUES ("86", "honda civic cvcc");
INSERT INTO "car_names" VALUES ("87", "fiat 131");
INSERT INTO "car_names" VALUES ("88", "opel rekord wagon");
INSERT INTO "car_names" VALUES ("89", "chevrolet chevelle malibu classic");
INSERT INTO "car_names" VALUES ("90", "dodge coronet brougham");
INSERT INTO "car_names" VALUES ("91", "ford gran torino");
INSERT INTO "car_names" VALUES ("92", "plymouth valiant custom");
INSERT INTO "car_names" VALUES ("93", "pontiac grand prix");
INSERT INTO "car_names" VALUES ("94", "chrysler cordoba");
INSERT INTO "car_names" VALUES ("95", "chevrolet monza 2+2");
INSERT INTO "car_names" VALUES ("96", "ford pinto");
INSERT INTO "car_names" VALUES ("97", "toyota corolla");
INSERT INTO "car_names" VALUES ("98", "ford f100");
INSERT INTO "car_names" VALUES ("99", "chevrolet c10");
INSERT INTO "car_names" VALUES ("100", "dodge d100");
INSERT INTO "car_names" VALUES ("101", "honda accord cvcc");
INSERT INTO "car_names" VALUES ("102", "buick opel isuzu deluxe");
INSERT INTO "car_names" VALUES ("103", "renault 5 gtl");
INSERT INTO "car_names" VALUES ("104", "plymouth volare custom");
INSERT INTO "car_names" VALUES ("105", "ford granada ghia");
INSERT INTO "car_names" VALUES ("106", "pontiac grand prix lj");
INSERT INTO "car_names" VALUES ("107", "chevrolet monte carlo landau");
INSERT INTO "car_names" VALUES ("108", "chrysler lebaron town & country sw");
INSERT INTO "car_names" VALUES ("109", "volkswagen rabbit custom");
INSERT INTO "car_names" VALUES ("110", "honda accord lx");
INSERT INTO "car_names" VALUES ("111", "plymouth horizon");
INSERT INTO "car_names" VALUES ("112", "dodge omni");
INSERT INTO "car_names" VALUES ("113", "datsun 200-sx");
INSERT INTO "car_names" VALUES ("114", "mazda rx-7 gs");
INSERT INTO "car_names" VALUES ("115", "plymouth sapporo");
INSERT INTO "car_names" VALUES ("116", "oldsmobile cutlass salon brougham");
INSERT INTO "car_names" VALUES ("117", "buick century special");
INSERT INTO "car_names" VALUES ("118", "mercury grand marquis");
INSERT INTO "car_names" VALUES ("119", "dodge st. regis");
INSERT INTO "car_names" VALUES ("120", "ford ltd landau");
INSERT INTO "car_names" VALUES ("121", "chevrolet caprice classic");
INSERT INTO "car_names" VALUES ("122", "peugeot 604sl");
INSERT INTO "car_names" VALUES ("123", "volkswagen rabbit custom diesel");
INSERT INTO "car_names" VALUES ("124", "ford fiesta");
INSERT INTO "car_names" VALUES ("125", "mazda glc deluxe");
INSERT INTO "car_names" VALUES ("126", "datsun 210");
INSERT INTO "car_names" VALUES ("127", "toyota corolla liftback");
INSERT INTO "car_names" VALUES ("128", "amc concord");
INSERT INTO "car_names" VALUES ("129", "buick century limited");
INSERT INTO "car_names" VALUES ("130", "oldsmobile cutlass salon brougham");
INSERT INTO "car_names" VALUES ("131", "chrysler lebaron salon");
INSERT INTO "car_names" VALUES ("132", "chevrolet citation");
INSERT INTO "car_names" VALUES ("133", "pontiac phoenix");
INSERT INTO "car_names" VALUES ("134", "ford fairmont");
INSERT INTO "car_names" VALUES ("135", "amc concord");
INSERT INTO "car_names" VALUES ("136", "dodge aspen");
INSERT INTO "car_names" VALUES ("137", "plymouth volare");
INSERT INTO "car_names" VALUES ("138", "chevrolet malibu");
INSERT INTO "car_names" VALUES ("139", "chrysler lebaron");
INSERT INTO "car_names" VALUES ("140", "ford ltd");
INSERT INTO "car_names" VALUES ("141", "mercury grand marquis");
INSERT INTO "car_names" VALUES ("142", "dodge st. regis");
INSERT INTO "car_names" VALUES ("143", "buick estate wagon sw");
INSERT INTO "car_names" VALUES ("144", "ford country squire sw");
INSERT INTO "car_names" VALUES ("145", "chrysler lebaron wagon sw");
INSERT INTO "car_names" VALUES ("146", "volkswagen rabbit custom");
INSERT INTO "car_names" VALUES ("147", "datsun 210");
INSERT INTO "car_names" VALUES ("148", "toyota corolla tercel");
INSERT INTO "car_names" VALUES ("149", "mazda glc");
INSERT INTO "car_names" VALUES ("150", "plymouth horizon 4");
INSERT INTO "car_names" VALUES ("151", "ford escort 4w");
INSERT INTO "car_names" VALUES ("152", "honda civic 1500 gl");
INSERT INTO "car_names" VALUES ("153", "datsun 310 gx");
INSERT INTO "car_names" VALUES ("154", "amc concord");
INSERT INTO "car_names" VALUES ("155", "chevrolet citation");
INSERT INTO "car_names" VALUES ("156", "plymouth reliant");
INSERT INTO "car_names" VALUES ("157", "buick skylark");
INSERT INTO "car_names" VALUES ("158", "dodge aries wagon sw");
INSERT INTO "car_names" VALUES ("159", "chevrolet citation wagon sw");
INSERT INTO "car_names" VALUES ("160", "plymouth reliant sw");
INSERT INTO "car_names" VALUES ("161", "ford escort 2h");
INSERT INTO "car_names" VALUES ("162", "toyota corolla");
INSERT INTO "car_names" VALUES ("163", "mazda glc custom l");
INSERT INTO "car_names" VALUES ("164", "mazda glc custom");
INSERT INTO "car_names" VALUES ("165", "plymouth horizon miser");
INSERT INTO "car_names" VALUES ("166", "mercury lynx l");
INSERT INTO "car_names" VALUES ("167", "nissan stanza xe");
INSERT INTO "car_names" VALUES ("168", "honda accord");
INSERT INTO "car_names" VALUES ("169", "toyota cressida");
INSERT INTO "car_names" VALUES ("170", "datsun 810 maxima");
INSERT INTO "car_names" VALUES ("171", "buick century");
INSERT INTO "car_names" VALUES ("172", "oldsmobile cutlass ciera diesel");
INSERT INTO "car_names" VALUES ("173", "chrysler lebaron medallion");
INSERT INTO "car_names" VALUES ("174", "ford granada l");
INSERT INTO "car_names" VALUES ("175", "toyota celica gt");
INSERT INTO "car_names" VALUES ("176", "dodge charger 2.2");
INSERT INTO "car_names" VALUES ("177", "chevrolet camaro");
INSERT INTO "car_names" VALUES ("178", "ford mustang gl");
INSERT INTO "car_names" VALUES ("179", "honda accord");
INSERT INTO "car_names" VALUES ("180", "toyota corolla");
INSERT INTO "car_names" VALUES ("181", "datsun 310");
INSERT INTO "car_names" VALUES ("182", "chrysler new yorker brougham");
INSERT INTO "car_names" VALUES ("183", "dodge diplomat");
INSERT INTO "car_names" VALUES ("184", "buick century limited");
INSERT INTO "car_names" VALUES ("185", "oldsmobile cutlass ciera");
INSERT INTO "car_names" VALUES ("186", "chevrolet malibu classic sw");
INSERT INTO "car_names" VALUES ("187", "chrysler lebaron wagon sw");
INSERT INTO "car_names" VALUES ("188", "ford ltd sw");
INSERT INTO "car_names" VALUES ("189", "volkswagen rabbit");
INSERT INTO "car_names" VALUES ("190", "honda civic");
INSERT INTO "car_names" VALUES ("191", "honda civic auto");
INSERT INTO "car_names" VALUES ("192", "datsun 310 gx");
INSERT INTO "car_names" VALUES ("193", "pontiac j2000 se hatchback");
INSERT INTO "car_names" VALUES ("194", "dodge aries se");
INSERT INTO "car_names" VALUES ("195", "plymouth reliant se");
INSERT INTO "car_names" VALUES ("196", "ford escort 4w");
INSERT INTO "car_names" VALUES ("197", "toyota corolla");
INSERT INTO "car_names" VALUES ("198", "datsun 200sx");
INSERT INTO "car_names" VALUES ("199", "mazda 626");
INSERT INTO "car_names" VALUES ("200", "peugeot 505s turbo diesel");
INSERT INTO "car_names" VALUES ("201", "volkswagen rabbit c diesel");
INSERT INTO "car_names" VALUES ("202", "volkswagen dasher diesel");
INSERT INTO "car_names" VALUES ("203", "audi 4000");
INSERT INTO "car_names" VALUES ("204", "renault 18i");
INSERT INTO "car_names" VALUES ("205", "oldsmobile cutlass ciera diesel");
INSERT INTO "car_names" VALUES ("206", "chrysler lebaron medallion sw");
INSERT INTO "car_names" VALUES ("207", "ford granada l");
INSERT INTO "car_names" VALUES ("208", "toyota celica gt");
INSERT INTO "car_names" VALUES ("209", "dodge charger 2.2");
INSERT INTO "car_names" VALUES ("210", "chevrolet camaro");
INSERT INTO "car_names" VALUES ("211", "ford mustang gl");
INSERT INTO "car_names" VALUES ("212", "honda accord");
INSERT INTO "car_names" VALUES ("213", "toyota corolla");
INSERT INTO "car_names" VALUES ("214", "datsun 310");
INSERT INTO "car_names" VALUES ("215", "chrysler new yorker brougham");
INSERT INTO "car_names" VALUES ("216", "dodge diplomat");
INSERT INTO "car_names" VALUES ("217", "buick century limited");
INSERT INTO "car_names" VALUES ("218", "oldsmobile cutlass ciera");
INSERT INTO "car_names" VALUES ("219", "chevrolet malibu classic sw");
INSERT INTO "car_names" VALUES ("220", "chrysler lebaron wagon sw");
INSERT INTO "car_names" VALUES ("221", "ford ltd sw");
INSERT INTO "car_names" VALUES ("222", "volkswagen rabbit");
INSERT INTO "car_names" VALUES ("223", "honda civic");
INSERT INTO "car_names" VALUES ("224", "honda civic auto");
INSERT INTO "car_names" VALUES ("225", "datsun 310 gx");
INSERT INTO "car_names" VALUES ("226", "pontiac j2000 se hatchback");
INSERT INTO "car_names" VALUES ("227", "dodge aries se");
INSERT INTO "car_names" VALUES ("228", "plymouth reliant se");
INSERT INTO "car_names" VALUES ("229", "ford escort 4w");
INSERT INTO "car_names" VALUES ("230", "toyota corolla");
INSERT INTO "car_names" VALUES ("231", "datsun 200sx");
INSERT INTO "car_names" VALUES ("232", "mazda 626");
INSERT INTO "car_names" VALUES ("233", "peugeot 505s turbo diesel");
INSERT INTO "car_names" VALUES ("234", "volkswagen rabbit c diesel");
INSERT INTO "car_names" VALUES ("235", "volkswagen dasher diesel");
INSERT INTO "car_names" VALUES ("236", "audi 4000");
INSERT INTO "car_names" VALUES ("237", "renault 18i");
INSERT INTO "car_names" VALUES ("238", "oldsmobile cutlass ciera diesel");
INSERT INTO "car_names" VALUES ("239", "chrysler lebaron medallion sw");
INSERT INTO "car_names" VALUES ("240", "ford granada l");
INSERT INTO "car_names" VALUES ("241", "toyota celica gt");
INSERT INTO "car_names" VALUES ("242", "dodge charger 2.2");
INSERT INTO "car_names" VALUES ("243", "chevrolet camaro");
INSERT INTO "car_names" VALUES ("244", "ford mustang gl");
INSERT INTO "car_names" VALUES ("245", "honda accord");
INSERT INTO "car_names" VALUES ("246", "toyota corolla");
INSERT INTO "car_names" VALUES ("247", "datsun 310");
INSERT INTO "car_names" VALUES ("248", "chrysler new yorker brougham");
INSERT INTO "car_names" VALUES ("249", "dodge diplomat");
INSERT INTO "car_names" VALUES ("250", "buick century limited");
INSERT INTO "car_names" VALUES ("251", "oldsmobile cutlass ciera");
INSERT INTO "car_names" VALUES ("252", "chevrolet malibu classic sw");
INSERT INTO "car_names" VALUES ("253", "chrysler lebaron wagon sw");
INSERT INTO "car_names" VALUES ("254", "ford ltd sw");
INSERT INTO "car_names" VALUES ("255", "volkswagen rabbit");
INSERT INTO "car_names" VALUES ("256", "honda civic");
INSERT INTO "car_names" VALUES ("257", "honda civic auto");
INSERT INTO "car_names" VALUES ("258", "datsun 310 gx");
INSERT INTO "car_names" VALUES ("259", "pontiac j2000 se hatchback");
INSERT INTO "car_names" VALUES ("260", "dodge aries se");
INSERT INTO "car_names" VALUES ("261", "plymouth reliant se");
INSERT INTO "car_names" VALUES ("262", "ford escort 4w");
INSERT INTO "car_names" VALUES ("263", "toyota corolla");
INSERT INTO "car_names" VALUES ("264", "datsun 200sx");
INSERT INTO "car_names" VALUES ("265", "mazda 626");
INSERT INTO "car_names" VALUES ("266", "peugeot 505s turbo diesel");
INSERT INTO "car_names" VALUES ("267", "volkswagen rabbit c diesel");
INSERT INTO "car_names" VALUES ("268", "volkswagen dasher diesel");
INSERT INTO "car_names" VALUES ("269", "audi 4000");
INSERT INTO "car_names" VALUES ("270", "renault 18i");
INSERT INTO "car_names" VALUES ("271", "oldsmobile cutlass ciera diesel");
INSERT INTO "car_names" VALUES ("272", "chrysler lebaron medallion sw");
INSERT INTO "car_names" VALUES ("273", "ford granada l");
INSERT INTO "car_names" VALUES ("274", "toyota celica gt");
INSERT INTO "car_names" VALUES ("275", "dodge charger 2.2");
INSERT INTO "car_names" VALUES ("276", "chevrolet camaro");
INSERT INTO "car_names" VALUES ("277", "ford mustang gl");
INSERT INTO "car_names" VALUES ("278", "honda accord");
INSERT INTO "car_names" VALUES ("279", "toyota corolla");
INSERT INTO "car_names" VALUES ("280", "datsun 310");
INSERT INTO "car_names" VALUES ("281", "chrysler new yorker brougham");
INSERT INTO "car_names" VALUES ("282", "dodge diplomat");
INSERT INTO "car_names" VALUES ("283", "buick century limited");
INSERT INTO "car_names" VALUES ("284", "oldsmobile cutlass ciera");
INSERT INTO "car_names" VALUES ("285", "chevrolet malibu classic sw");
INSERT INTO "car_names" VALUES ("286", "chrysler lebaron wagon sw");
INSERT INTO "car_names" VALUES ("287", "ford ltd sw");
INSERT INTO "car_names" VALUES ("288", "volkswagen rabbit");
INSERT INTO "car_names" VALUES ("289", "honda civic");
INSERT INTO "car_names" VALUES ("290", "honda civic auto");
INSERT INTO "car_names" VALUES ("291", "datsun 310 gx");
INSERT INTO "car_names" VALUES ("292", "pontiac j2000 se hatchback");
INSERT INTO "car_names" VALUES ("293", "dodge aries se");
INSERT INTO "car_names" VALUES ("294", "plymouth reliant se");
INSERT INTO "car_names" VALUES ("295", "ford escort 4w");
INSERT INTO "car_names" VALUES ("296", "toyota corolla");
INSERT INTO "car_names" VALUES ("297", "datsun 200sx");
INSERT INTO "car_names" VALUES ("298", "mazda 626");
INSERT INTO "car_names" VALUES ("299", "peugeot 505s turbo diesel");