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")
);





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 vega 2300");
INSERT INTO "car_names" VALUES ("13", "datsun 1200");
INSERT INTO "car_names" VALUES ("14", "toyota corona mark ii");
INSERT INTO "car_names" VALUES ("15", "plymouth duster");
INSERT INTO "car_names" VALUES ("16", "audi 100 ls");
INSERT INTO "car_names" VALUES ("17", "saab 99e");
INSERT INTO "car_names" VALUES ("18", "bmw 2002");
INSERT INTO "car_names" VALUES ("19", "peugeot 504");
INSERT INTO "car_names" VALUES ("20", "volkswagen type 3");
INSERT INTO "car_names" VALUES ("21", "volvo 145e sw");
INSERT INTO "car_names" VALUES ("22", "volkswagen 411 sw");
INSERT INTO "car_names" VALUES ("23", "peugeot 304 sw");
INSERT INTO "car_names" VALUES ("24", "fiat 124 sw");
INSERT INTO "car_names" VALUES ("25", "opel manta");
INSERT INTO "car_names" VALUES ("26", "audi 100ls");
INSERT INTO "car_names" VALUES ("27", "fiat 128");
INSERT INTO "car_names" VALUES ("28", "ford pinto");
INSERT INTO "car_names" VALUES ("29", "datsun 510");
INSERT INTO "car_names" VALUES ("30", "mercury capri 2000");
INSERT INTO "car_names" VALUES ("31", "amc gremlin");
INSERT INTO "car_names" VALUES ("32", "plymouth satellite custom");
INSERT INTO "car_names" VALUES ("33", "chevrolet chevelle malibu");
INSERT INTO "car_names" VALUES ("34", "ford torino 500");
INSERT INTO "car_names" VALUES ("35", "amc matador");
INSERT INTO "car_names" VALUES ("36", "chevrolet impala");
INSERT INTO "car_names" VALUES ("37", "pontiac grand prix");
INSERT INTO "car_names" VALUES ("38", "fiat 124 sport coupe");
INSERT INTO "car_names" VALUES ("39", "chevrolet monte carlo");
INSERT INTO "car_names" VALUES ("40", "plymouth fury gran sedan");
INSERT INTO "car_names" VALUES ("41", "chrysler new yorker brougham");
INSERT INTO "car_names" VALUES ("42", "buick electra 225 custom");
INSERT INTO "car_names" VALUES ("43", "amc ambassador sst");
INSERT INTO "car_names" VALUES ("44", "plymouth valiant");
INSERT INTO "car_names" VALUES ("45", "chevrolet nova custom");
INSERT INTO "car_names" VALUES ("46", "datsun 610");
INSERT INTO "car_names" VALUES ("47", "toyota mark ii");
INSERT INTO "car_names" VALUES ("48", "plymouth satellite custom sw");
INSERT INTO "car_names" VALUES ("49", "ford gran torino sw");
INSERT INTO "car_names" VALUES ("50", "chrysler newport royal");
INSERT INTO "car_names" VALUES ("51", "mazda rx2 coupe");
INSERT INTO "car_names" VALUES ("52", "amc matador sw");
INSERT INTO "car_names" VALUES ("53", "chevrolet chevelle concours sw");
INSERT INTO "car_names" VALUES ("54", "ford gran torino");
INSERT INTO "car_names" VALUES ("55", "plymouth satellite custom");
INSERT INTO "car_names" VALUES ("56", "volkswagen dasher");
INSERT INTO "car_names" VALUES ("57", "opel rekord kadett");
INSERT INTO "car_names" VALUES ("58", "audi fox");
INSERT INTO "car_names" VALUES ("59", "volkswagen rabbit");
INSERT INTO "car_names" VALUES ("60", "datsun b210");
INSERT INTO "car_names" VALUES ("61", "toyota corolla 1200");
INSERT INTO "car_names" VALUES ("62", "fiat 128");
INSERT INTO "car_names" VALUES ("63", "fiat 124 tc");
INSERT INTO "car_names" VALUES ("64", "honda civic");
INSERT INTO "car_names" VALUES ("65", "subaru");
INSERT INTO "car_names" VALUES ("66", "fiat x1-9");
INSERT INTO "car_names" VALUES ("67", "plymouth valiant custom");
INSERT INTO "car_names" VALUES ("68", "chevrolet nova");
INSERT INTO "car_names" VALUES ("69", "ford maverick");
INSERT INTO "car_names" VALUES ("70", "amc hornet");
INSERT INTO "car_names" VALUES ("71", "pontiac ventura");
INSERT INTO "car_names" VALUES ("72", "chevrolet chevelle");
INSERT INTO "car_names" VALUES ("73", "pontiac lemans v8");
INSERT INTO "car_names" VALUES ("74", "ford gran torino");
INSERT INTO "car_names" VALUES ("75", "chrysler new yorker brougham");
INSERT INTO "car_names" VALUES ("76", "buick century 350");
INSERT INTO "car_names" VALUES ("77", "amc matador");
INSERT INTO "car_names" VALUES ("78", "chevrolet monza 2+2");
INSERT INTO "car_names" VALUES ("79", "ford pinto");
INSERT INTO "car_names" VALUES ("80", "toyota corolla");
INSERT INTO "car_names" VALUES ("81", "datsun b-210");
INSERT INTO "car_names" VALUES ("82", "fiat 131");
INSERT INTO "car_names" VALUES ("83", "opel manta");
INSERT INTO "car_names" VALUES ("84", "audi 100ls");
INSERT INTO "car_names" VALUES ("85", "peugeot 504");
INSERT INTO "car_names" VALUES ("86", "volvo 244dl");
INSERT INTO "car_names" VALUES ("87", "saab 99le");
INSERT INTO "car_names" VALUES ("88", "honda civic cvcc");
INSERT INTO "car_names" VALUES ("89", "fiat 128r");
INSERT INTO "car_names" VALUES ("90", "plymouth volare custom");
INSERT INTO "car_names" VALUES ("91", "ford granada gl");
INSERT INTO "car_names" VALUES ("92", "chrysler cordoba");
INSERT INTO "car_names" VALUES ("93", "chevrolet chevelle malibu classic");
INSERT INTO "car_names" VALUES ("94", "datsun f-10 hatchback");
INSERT INTO "car_names" VALUES ("95", "plymouth volare premier v8");
INSERT INTO "car_names" VALUES ("96", "dodge aspen se");
INSERT INTO "car_names" VALUES ("97", "ford granada");
INSERT INTO "car_names" VALUES ("98", "chrysler new yorker brougham");
INSERT INTO "car_names" VALUES ("99", "buick skylark");
INSERT INTO "car_names" VALUES ("100", "amc hornet");
INSERT INTO "car_names" VALUES ("101", "pontiac sunbird coupe");
INSERT INTO "car_names" VALUES ("102", "chevrolet monza 99");
INSERT INTO "car_names" VALUES ("103", "fiat 600");
INSERT INTO "car_names" VALUES ("104", "toyota corolla liftback");
INSERT INTO "car_names" VALUES ("105", "plymouth volare custom");
INSERT INTO "car_names" VALUES ("106", "ford fairmont auto");
INSERT INTO "car_names" VALUES ("107", "chrysler lebaron salon");
INSERT INTO "car_names" VALUES ("108", "buick century special");
INSERT INTO "car_names" VALUES ("109", "pontiac grand prix lj");
INSERT INTO "car_names" VALUES ("110", "amc concord");
INSERT INTO "car_names" VALUES ("111", "chevrolet malibu");
INSERT INTO "car_names" VALUES ("112", "dodge diplomat");
INSERT INTO "car_names" VALUES ("113", "ford fairmont futura");
INSERT INTO "car_names" VALUES ("114", "volkswagen rabbit custom");
INSERT INTO "car_names" VALUES ("115", "honda accord cvcc");
INSERT INTO "car_names" VALUES ("116", "datsun 200-sx");
INSERT INTO "car_names" VALUES ("117", "mazda glc deluxe");
INSERT INTO "car_names" VALUES ("118", "plymouth horizon hatchback");
INSERT INTO "car_names" VALUES ("119", "dodge omni hatchback");
INSERT INTO "car_names" VALUES ("120", "toyota celica gt liftback");
INSERT INTO "car_names" VALUES ("121", "plymouth sapporo");
INSERT INTO "car_names" VALUES ("122", "oldsmobile cutlass salon brougham");
INSERT INTO "car_names" VALUES ("123", "dodge magnum xe");
INSERT INTO "car_names" VALUES ("124", "buick regal sport coupe turbo");
INSERT INTO "car_names" VALUES ("125", "ford futura");
INSERT INTO "car_names" VALUES ("126", "amc spirit dl");
INSERT INTO "car_names" VALUES ("127", "chevrolet citation");
INSERT INTO "car_names" VALUES ("128", "pontiac phoenix");
INSERT INTO "car_names" VALUES ("129", "ford fairmont");
INSERT INTO "car_names" VALUES ("130", "amc concord");
INSERT INTO "car_names" VALUES ("131", "dodge aspen");
INSERT INTO "car_names" VALUES ("132", "plymouth horizon");
INSERT INTO "car_names" VALUES ("133", "datsun 210");
INSERT INTO "car_names" VALUES ("134", "honda civic 1500 gl");
INSERT INTO "car_names" VALUES ("135", "toyota corolla tercel");
INSERT INTO "car_names" VALUES ("136", "mazda glc");
INSERT INTO "car_names" VALUES ("137", "plymouth reliant");
INSERT INTO "car_names" VALUES ("138", "buick skylark");
INSERT INTO "car_names" VALUES ("139", "dodge aries wagon sw");
INSERT INTO "car_names" VALUES ("140", "chevrolet citation");
INSERT INTO "car_names" VALUES ("141", "plymouth reliant");
INSERT INTO "car_names" VALUES ("142", "volkswagen rabbit");
INSERT INTO "car_names" VALUES ("143", "honda civic");
INSERT INTO "car_names" VALUES ("144", "datsun 310 gx");
INSERT INTO "car_names" VALUES ("145", "mazda glc custom l");
INSERT INTO "car_names" VALUES ("146", "mazda glc custom");
INSERT INTO "car_names" VALUES ("147", "plymouth horizon 4");
INSERT INTO "car_names" VALUES ("148", "ford escort 4w");
INSERT INTO "car_names" VALUES ("149", "ford escort 2h");
INSERT INTO "car_names" VALUES ("150", "volkswagen jetta");
INSERT INTO "car_names" VALUES ("151", "honda prelude");
INSERT INTO "car_names" VALUES ("152", "toyota corolla");
INSERT INTO "car_names" VALUES ("153", "datsun 200sx");
INSERT INTO "car_names" VALUES ("154", "mazda 626");
INSERT INTO "car_names" VALUES ("155", "peugeot 604sl");
INSERT INTO "car_names" VALUES ("156", "volvo diesel");
INSERT INTO "car_names" VALUES ("157", "toyota cressida");
INSERT INTO "car_names" VALUES ("158", "datsun 810 maxima");
INSERT INTO "car_names" VALUES ("159", "buick skylark limited");
INSERT INTO "car_names" VALUES ("160", "oldsmobile cutlass ciera diesel");
INSERT INTO "car_names" VALUES ("161", "chrysler lebaron medallion");
INSERT INTO "car_names" VALUES ("162", "ford granada l");
INSERT INTO "car_names" VALUES ("163", "toyota celica gt");
INSERT INTO "car_names" VALUES ("164", "dodge charger 2.2");
INSERT INTO "car_names" VALUES ("165", "chevrolet camaro");
INSERT INTO "car_names" VALUES ("166", "ford mustang gl");
INSERT INTO "car_names" VALUES ("167", "honda accord");
INSERT INTO "car_names" VALUES ("168", "pontiac j2000 se hatchback");
INSERT INTO "car_names" VALUES ("169", "dodge aries se");
INSERT INTO "car_names" VALUES ("170", "ford escort wagon");
INSERT INTO "car_names" VALUES ("171", "toyota corolla");
INSERT INTO "car_names" VALUES ("172", "honda civic custom");
INSERT INTO "car_names" VALUES ("173", "honda accord gl");
INSERT INTO "car_names" VALUES ("174", "chevrolet cavalier");
INSERT INTO "car_names" VALUES ("175", "chevrolet cavalier wagon");
INSERT INTO "car_names" VALUES ("176", "chevrolet cavalier 2-door");
INSERT INTO "car_names" VALUES ("177", "pontiac j2000 sedan");
INSERT INTO "car_names" VALUES ("178", "dodge aries wagon");
INSERT INTO "car_names" VALUES ("179", "plymouth reliant sedan");
INSERT INTO "car_names" VALUES ("180", "ford escort 2.0");
INSERT INTO "car_names" VALUES ("181", "toyota starlet");
INSERT INTO "car_names" VALUES ("182", "plymouth champ");
INSERT INTO "car_names" VALUES ("183", "honda civic 1300");
INSERT INTO "car_names" VALUES ("184", "datsun 210 mpg");
INSERT INTO "car_names" VALUES ("185", "mazda glc");
INSERT INTO "car_names" VALUES ("186", "dodge rampage");
INSERT INTO "car_names" VALUES ("187", "ford ranger");
INSERT INTO "car_names" VALUES ("188", "honda accord");
INSERT INTO "car_names" VALUES ("189", "toyota corolla");
INSERT INTO "car_names" VALUES ("190", "datsun 310");
INSERT INTO "car_names" VALUES ("191", "chrysler lebaron salon");
INSERT INTO "car_names" VALUES ("192", "chevrolet cavalier");
INSERT INTO "car_names" VALUES ("193", "ford ltd");
INSERT INTO "car_names" VALUES ("194", "buick century limited");
INSERT INTO "car_names" VALUES ("195", "oldsmobile cutlass ciera");
INSERT INTO "car_names" VALUES ("196", "dodge aries se");
INSERT INTO "car_names" VALUES ("197", "pontiac phoenix");
INSERT INTO "car_names" VALUES ("198", "volkswagen rabbit");
INSERT INTO "car_names" VALUES ("199", "datsun 310");
INSERT INTO "car_names" VALUES ("200", "honda civic");
INSERT INTO "car_names" VALUES ("201", "honda accord");
INSERT INTO "car_names" VALUES ("202", "plymouth horizon miser");
INSERT INTO "car_names" VALUES ("203", "mercury lynx l");
INSERT INTO "car_names" VALUES ("204", "nissan stanza xe");
INSERT INTO "car_names" VALUES ("205", "honda accord lx");
INSERT INTO "car_names" VALUES ("206", "volkswagen rabbit custom");
INSERT INTO "car_names" VALUES ("207", "mazda glc custom");
INSERT INTO "car_names" VALUES ("208", "dodge rampage");
INSERT INTO "car_names" VALUES ("209", "ford ranger");
INSERT INTO "car_names" VALUES ("210", "honda civic");
INSERT INTO "car_names" VALUES ("211", "honda civic auto");
INSERT INTO "car_names" VALUES ("212", "datsun 310 gx");
INSERT INTO "car_names" VALUES ("213", "buick century limited");
INSERT INTO "car_names" VALUES ("214", "oldsmobile cutlass ciera diesel");
INSERT INTO "car_names" VALUES ("215", "chrysler lebaron medallion");
INSERT INTO "car_names" VALUES ("216", "ford granada l");
INSERT INTO "car_names" VALUES ("217", "toyota celica gt");
INSERT INTO "car_names" VALUES ("218", "dodge charger 2.2");
INSERT INTO "car_names" VALUES ("219", "chevrolet camaro");
INSERT INTO "car_names" VALUES ("220", "ford mustang gl");
INSERT INTO "car_names" VALUES ("221", "honda accord");
INSERT INTO "car_names" VALUES ("222", "pontiac j2000 se hatchback");
INSERT INTO "car_names" VALUES ("223", "dodge aries se");
INSERT INTO "car_names" VALUES ("224", "ford escort wagon");
INSERT INTO "car_names" VALUES ("225", "toyota corolla");
INSERT INTO "car_names" VALUES ("226", "honda civic custom");
INSERT INTO "car_names" VALUES ("227", "honda accord gl");
INSERT INTO "car_names" VALUES ("228", "chevrolet cavalier");
INSERT INTO "car_names" VALUES ("229", "chevrolet cavalier wagon");
INSERT INTO "car_names" VALUES ("230", "chevrolet cavalier 2-door");
INSERT INTO "car_names" VALUES ("231", "pontiac j2000 sedan");
INSERT INTO "car_names" VALUES ("232", "dodge aries wagon");
INSERT INTO "car_names" VALUES ("233", "plymouth reliant sedan");
INSERT INTO "car_names" VALUES ("234", "ford escort 2.0");
INSERT INTO "car_names" VALUES ("235", "toyota starlet");
INSERT INTO "car_names" VALUES ("236", "plymouth champ");
INSERT INTO "car_names" VALUES ("237", "honda civic 1300");
INSERT INTO "car_names" VALUES ("238", "datsun 210 mpg");
INSERT INTO "car_names" VALUES ("239", "mazda glc");
INSERT INTO "car_names" VALUES ("240", "dodge rampage");
INSERT INTO "car_names" VALUES ("241", "ford ranger");
INSERT INTO "car_names" VALUES ("242", "honda accord");
INSERT INTO "car_names" VALUES ("243", "toyota corolla");
INSERT INTO "car_names" VALUES ("244", "datsun 310");
INSERT INTO "car_names" VALUES ("245", "chrysler lebaron salon");
INSERT INTO "car_names" VALUES ("246", "chevrolet cavalier");
INSERT INTO "car_names" VALUES ("247", "ford ltd");
INSERT INTO "car_names" VALUES ("248", "buick century limited");
INSERT INTO "car_names" VALUES ("249", "oldsmobile cutlass ciera");
INSERT INTO "car_names" VALUES ("250", "dodge aries se");
INSERT INTO "car_names" VALUES ("251", "pontiac phoenix");
INSERT INTO "car_names" VALUES ("252", "volkswagen rabbit");
INSERT INTO "car_names" VALUES ("253", "datsun 310");
INSERT INTO "car_names" VALUES ("254", "honda civic");
INSERT INTO "car_names" VALUES ("255", "honda accord");
INSERT INTO "car_names" VALUES ("256", "plymouth horizon miser");
INSERT INTO "car_names" VALUES ("257", "mercury lynx l");
INSERT INTO "car_names" VALUES ("258", "nissan stanza xe");
INSERT INTO "car_names" VALUES ("259", "honda accord lx");
INSERT INTO "car_names" VALUES ("260", "volkswagen rabbit custom");
INSERT INTO "car_names" VALUES ("261", "mazda glc custom");
INSERT INTO "car_names" VALUES ("262", "dodge rampage");
INSERT INTO "car_names" VALUES ("263", "ford ranger");
INSERT INTO "car_names" VALUES ("264", "honda civic");
INSERT INTO "car_names" VALUES ("265", "honda civic auto");
INSERT INTO "car_names" VALUES ("266", "datsun 310 gx");
INSERT INTO "cars_data" VALUES ("1", "18.0", "307.0", "130", "1970");
INSERT INTO "cars_data" VALUES ("2", "15.0", "350.0", "165", "1970");
INSERT INTO "cars_data" VALUES ("3", "18.0", "318.0", "150", "1970");
INSERT INTO "cars_data" VALUES ("4", "16.0", "304.0", "150", "1970");
INSERT INTO "cars_data" VALUES ("5", "17.0", "429.0", "198", "1970");
INSERT INTO "cars_data" VALUES ("6", "15.0", "429.0", "220", "1970");
INSERT INTO "cars_data" VALUES ("7", "14.0", "454.0", "220", "1970");
INSERT INTO "cars_data" VALUES ("8", "14.0", "440.0", "215", "1970");
INSERT INTO "cars_data" VALUES ("9", "14.0", "455.0", "225", "1970");
INSERT INTO "cars_data" VALUES ("10", "15.0", "390.0", "190", "1970");
INSERT INTO "cars_data" VALUES ("11", "27.0", "107.0", "90", "1970");
INSERT INTO "cars_data" VALUES ("12", "28.0", "113.0", "95", "1971");
INSERT INTO "cars_data" VALUES ("13", "25.0", "97.0", "46", "1971");
INSERT INTO "cars_data" VALUES ("14", "24.0", "113.0", "95", "1971");