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