--SET SCHEMA FOR THE TUTORIAL
CREATE SCHEMA "TUTORIAL_PREDICTIVE";
SET SCHEMA "TUTORIAL_PREDICTIVE";

DROP TABLE "TUTORIAL_PREDICTIVE"."ACCOUNT_REVENUE";

CREATE COLUMN TABLE "TUTORIAL_PREDICTIVE"."ACCOUNT_REVENUE"(
	"ACCOUNTNR" VARCHAR(11),
	"LOCATION" VARCHAR(100),
	"TOTAL_AMOUNT" DOUBLE DEFAULT 0,
	PRIMARY KEY (
		"ACCOUNTNR"
	)
);

--Loading data via INSERTs
INSERT INTO "TUTORIAL_PREDICTIVE"."ACCOUNT_REVENUE" (accountnr,location,total_amount) VALUES ('82540748399','Netherlands',3850);
INSERT INTO "TUTORIAL_PREDICTIVE"."ACCOUNT_REVENUE" (accountnr,location,total_amount) VALUES ('99692723699','Morocco',92);
INSERT INTO "TUTORIAL_PREDICTIVE"."ACCOUNT_REVENUE" (accountnr,location,total_amount) VALUES ('98804020299','Israel',176);
INSERT INTO "TUTORIAL_PREDICTIVE"."ACCOUNT_REVENUE" (accountnr,location,total_amount) VALUES ('24364537999','Estonia',41528);
INSERT INTO "TUTORIAL_PREDICTIVE"."ACCOUNT_REVENUE" (accountnr,location,total_amount) VALUES ('97592208699','South Africa',308);
INSERT INTO "TUTORIAL_PREDICTIVE"."ACCOUNT_REVENUE" (accountnr,location,total_amount) VALUES ('55783852899','Niger',332);
INSERT INTO "TUTORIAL_PREDICTIVE"."ACCOUNT_REVENUE" (accountnr,location,total_amount) VALUES ('12338489699','Malaysia',582);
INSERT INTO "TUTORIAL_PREDICTIVE"."ACCOUNT_REVENUE" (accountnr,location,total_amount) VALUES ('66941296899','Angola',332);
INSERT INTO "TUTORIAL_PREDICTIVE"."ACCOUNT_REVENUE" (accountnr,location,total_amount) VALUES ('78341775899','Japan',7780);
INSERT INTO "TUTORIAL_PREDICTIVE"."ACCOUNT_REVENUE" (accountnr,location,total_amount) VALUES ('30205810399','Indonesia',665);
INSERT INTO "TUTORIAL_PREDICTIVE"."ACCOUNT_REVENUE" (accountnr,location,total_amount) VALUES ('35766575899','Madagascar',616);
INSERT INTO "TUTORIAL_PREDICTIVE"."ACCOUNT_REVENUE" (accountnr,location,total_amount) VALUES ('23270858999','Malta',3540);
INSERT INTO "TUTORIAL_PREDICTIVE"."ACCOUNT_REVENUE" (accountnr,location,total_amount) VALUES ('91578369899','Bahrain',231);
INSERT INTO "TUTORIAL_PREDICTIVE"."ACCOUNT_REVENUE" (accountnr,location,total_amount) VALUES ('76401095499','Central African Republic',412);
INSERT INTO "TUTORIAL_PREDICTIVE"."ACCOUNT_REVENUE" (accountnr,location,total_amount) VALUES ('00913274699','Namibia',71);
INSERT INTO "TUTORIAL_PREDICTIVE"."ACCOUNT_REVENUE" (accountnr,location,total_amount) VALUES ('50694975399','South Georgia and The South Sandwich Islands',176);
INSERT INTO "TUTORIAL_PREDICTIVE"."ACCOUNT_REVENUE" (accountnr,location,total_amount) VALUES ('01488053499','Solomon Islands',878);
INSERT INTO "TUTORIAL_PREDICTIVE"."ACCOUNT_REVENUE" (accountnr,location,total_amount) VALUES ('96932672899','Northern Mariana Islands',748);
INSERT INTO "TUTORIAL_PREDICTIVE"."ACCOUNT_REVENUE" (accountnr,location,total_amount) VALUES ('91282172899','Liberia',122);
INSERT INTO "TUTORIAL_PREDICTIVE"."ACCOUNT_REVENUE" (accountnr,location,total_amount) VALUES ('79787992099','Jordan',80);
INSERT INTO "TUTORIAL_PREDICTIVE"."ACCOUNT_REVENUE" (accountnr,location,total_amount) VALUES ('67397439699','El Salvador',539);
INSERT INTO "TUTORIAL_PREDICTIVE"."ACCOUNT_REVENUE" (accountnr,location,total_amount) VALUES ('63992562599','Macedonia',57);
INSERT INTO "TUTORIAL_PREDICTIVE"."ACCOUNT_REVENUE" (accountnr,location,total_amount) VALUES ('43356492199','San Marino',696);
INSERT INTO "TUTORIAL_PREDICTIVE"."ACCOUNT_REVENUE" (accountnr,location,total_amount) VALUES ('51670856799','Sao Tome and Principe',640);
INSERT INTO "TUTORIAL_PREDICTIVE"."ACCOUNT_REVENUE" (accountnr,location,total_amount) VALUES ('19947726599','Ukraine',2700);
INSERT INTO "TUTORIAL_PREDICTIVE"."ACCOUNT_REVENUE" (accountnr,location,total_amount) VALUES ('99834072799','Ukraine',8064);
INSERT INTO "TUTORIAL_PREDICTIVE"."ACCOUNT_REVENUE" (accountnr,location,total_amount) VALUES ('31917565199','French Guiana',27);
INSERT INTO "TUTORIAL_PREDICTIVE"."ACCOUNT_REVENUE" (accountnr,location,total_amount) VALUES ('90613141899','Ireland',369);
INSERT INTO "TUTORIAL_PREDICTIVE"."ACCOUNT_REVENUE" (accountnr,location,total_amount) VALUES ('75361130899','Guinea',92);
INSERT INTO "TUTORIAL_PREDICTIVE"."ACCOUNT_REVENUE" (accountnr,location,total_amount) VALUES ('39763551799','Jersey',385);
INSERT INTO "TUTORIAL_PREDICTIVE"."ACCOUNT_REVENUE" (accountnr,location,total_amount) VALUES ('94627738599','Equatorial Guinea',615);
INSERT INTO "TUTORIAL_PREDICTIVE"."ACCOUNT_REVENUE" (accountnr,location,total_amount) VALUES ('57356613099','Sao Tome and Principe',354);
INSERT INTO "TUTORIAL_PREDICTIVE"."ACCOUNT_REVENUE" (accountnr,location,total_amount) VALUES ('34330084699','Azerbaijan',949);
INSERT INTO "TUTORIAL_PREDICTIVE"."ACCOUNT_REVENUE" (accountnr,location,total_amount) VALUES ('02988459599','French Polynesia',418);
INSERT INTO "TUTORIAL_PREDICTIVE"."ACCOUNT_REVENUE" (accountnr,location,total_amount) VALUES ('79935287199','Korea, South',15);
INSERT INTO "TUTORIAL_PREDICTIVE"."ACCOUNT_REVENUE" (accountnr,location,total_amount) VALUES ('06403930099','Vanuatu',781);
INSERT INTO "TUTORIAL_PREDICTIVE"."ACCOUNT_REVENUE" (accountnr,location,total_amount) VALUES ('41841311499','Belarus',82);
INSERT INTO "TUTORIAL_PREDICTIVE"."ACCOUNT_REVENUE" (accountnr,location,total_amount) VALUES ('34791974399','Uzbekistan',984);
INSERT INTO "TUTORIAL_PREDICTIVE"."ACCOUNT_REVENUE" (accountnr,location,total_amount) VALUES ('24750820299','Ethiopia',791);
INSERT INTO "TUTORIAL_PREDICTIVE"."ACCOUNT_REVENUE" (accountnr,location,total_amount) VALUES ('68989297999','Anguilla',589);
INSERT INTO "TUTORIAL_PREDICTIVE"."ACCOUNT_REVENUE" (accountnr,location,total_amount) VALUES ('37448014599','Niger',42);
INSERT INTO "TUTORIAL_PREDICTIVE"."ACCOUNT_REVENUE" (accountnr,location,total_amount) VALUES ('41325924899','Isle of Man',233);
INSERT INTO "TUTORIAL_PREDICTIVE"."ACCOUNT_REVENUE" (accountnr,location,total_amount) VALUES ('83463321899','United Arab Emirates',535);
INSERT INTO "TUTORIAL_PREDICTIVE"."ACCOUNT_REVENUE" (accountnr,location,total_amount) VALUES ('87960002399','Albania',800);
INSERT INTO "TUTORIAL_PREDICTIVE"."ACCOUNT_REVENUE" (accountnr,location,total_amount) VALUES ('42469535999','Georgia',783);
INSERT INTO "TUTORIAL_PREDICTIVE"."ACCOUNT_REVENUE" (accountnr,location,total_amount) VALUES ('18539856499','Djibouti',716);
INSERT INTO "TUTORIAL_PREDICTIVE"."ACCOUNT_REVENUE" (accountnr,location,total_amount) VALUES ('32610094899','Cameroon',482);
INSERT INTO "TUTORIAL_PREDICTIVE"."ACCOUNT_REVENUE" (accountnr,location,total_amount) VALUES ('78884234499','Guyana',912);
INSERT INTO "TUTORIAL_PREDICTIVE"."ACCOUNT_REVENUE" (accountnr,location,total_amount) VALUES ('93904093399','Mauritania',495);
INSERT INTO "TUTORIAL_PREDICTIVE"."ACCOUNT_REVENUE" (accountnr,location,total_amount) VALUES ('81519284299','Martinique',387);
INSERT INTO "TUTORIAL_PREDICTIVE"."ACCOUNT_REVENUE" (accountnr,location,total_amount) VALUES ('94861577199','Grenada',89);
INSERT INTO "TUTORIAL_PREDICTIVE"."ACCOUNT_REVENUE" (accountnr,location,total_amount) VALUES ('23701374899','Sri Lanka',161);
INSERT INTO "TUTORIAL_PREDICTIVE"."ACCOUNT_REVENUE" (accountnr,location,total_amount) VALUES ('10334180899','Gambia',473);
INSERT INTO "TUTORIAL_PREDICTIVE"."ACCOUNT_REVENUE" (accountnr,location,total_amount) VALUES ('63747550799','Ukraine',3715);
INSERT INTO "TUTORIAL_PREDICTIVE"."ACCOUNT_REVENUE" (accountnr,location,total_amount) VALUES ('66384175199','Tokelau',946);
INSERT INTO "TUTORIAL_PREDICTIVE"."ACCOUNT_REVENUE" (accountnr,location,total_amount) VALUES ('70471211599','Tokelau',45);
INSERT INTO "TUTORIAL_PREDICTIVE"."ACCOUNT_REVENUE" (accountnr,location,total_amount) VALUES ('94537787299','Bosnia and Herzegovina',956);
INSERT INTO "TUTORIAL_PREDICTIVE"."ACCOUNT_REVENUE" (accountnr,location,total_amount) VALUES ('41888115799','Thailand',101);
INSERT INTO "TUTORIAL_PREDICTIVE"."ACCOUNT_REVENUE" (accountnr,location,total_amount) VALUES ('84851632199','Bonaire, Sint Eustatius and Saba',957);
INSERT INTO "TUTORIAL_PREDICTIVE"."ACCOUNT_REVENUE" (accountnr,location,total_amount) VALUES ('12369169799','Romania',323);
INSERT INTO "TUTORIAL_PREDICTIVE"."ACCOUNT_REVENUE" (accountnr,location,total_amount) VALUES ('10320338499','Sudan',128);
INSERT INTO "TUTORIAL_PREDICTIVE"."ACCOUNT_REVENUE" (accountnr,location,total_amount) VALUES ('23973062599','Philippines',558);
INSERT INTO "TUTORIAL_PREDICTIVE"."ACCOUNT_REVENUE" (accountnr,location,total_amount) VALUES ('80234682699','Grenada',212);
INSERT INTO "TUTORIAL_PREDICTIVE"."ACCOUNT_REVENUE" (accountnr,location,total_amount) VALUES ('92435601999','Norway',63305);
INSERT INTO "TUTORIAL_PREDICTIVE"."ACCOUNT_REVENUE" (accountnr,location,total_amount) VALUES ('05213022999','Samoa',714);
INSERT INTO "TUTORIAL_PREDICTIVE"."ACCOUNT_REVENUE" (accountnr,location,total_amount) VALUES ('34385740899','Guam',413);
INSERT INTO "TUTORIAL_PREDICTIVE"."ACCOUNT_REVENUE" (accountnr,location,total_amount) VALUES ('93686420399','Niger',957);
INSERT INTO "TUTORIAL_PREDICTIVE"."ACCOUNT_REVENUE" (accountnr,location,total_amount) VALUES ('39548974899','Aruba',89);
INSERT INTO "TUTORIAL_PREDICTIVE"."ACCOUNT_REVENUE" (accountnr,location,total_amount) VALUES ('14873205199','Guinea-Bissau',485);
INSERT INTO "TUTORIAL_PREDICTIVE"."ACCOUNT_REVENUE" (accountnr,location,total_amount) VALUES ('70546477699','Tanzania',364);
INSERT INTO "TUTORIAL_PREDICTIVE"."ACCOUNT_REVENUE" (accountnr,location,total_amount) VALUES ('09430444999','Seychelles',323);
INSERT INTO "TUTORIAL_PREDICTIVE"."ACCOUNT_REVENUE" (accountnr,location,total_amount) VALUES ('58371537199','Cocos (Keeling) Islands',733);
INSERT INTO "TUTORIAL_PREDICTIVE"."ACCOUNT_REVENUE" (accountnr,location,total_amount) VALUES ('25609325299','Tajikistan',167);
INSERT INTO "TUTORIAL_PREDICTIVE"."ACCOUNT_REVENUE" (accountnr,location,total_amount) VALUES ('85253147299','Ghana',70);
INSERT INTO "TUTORIAL_PREDICTIVE"."ACCOUNT_REVENUE" (accountnr,location,total_amount) VALUES ('90265537999','Peru',96);
INSERT INTO "TUTORIAL_PREDICTIVE"."ACCOUNT_REVENUE" (accountnr,location,total_amount) VALUES ('87529168299','Bolivia',642);
INSERT INTO "TUTORIAL_PREDICTIVE"."ACCOUNT_REVENUE" (accountnr,location,total_amount) VALUES ('65449829999','Norfolk Island',566);
INSERT INTO "TUTORIAL_PREDICTIVE"."ACCOUNT_REVENUE" (accountnr,location,total_amount) VALUES ('75845729799','Jamaica',568);
INSERT INTO "TUTORIAL_PREDICTIVE"."ACCOUNT_REVENUE" (accountnr,location,total_amount) VALUES ('04342023699','Germany',55656);
INSERT INTO "TUTORIAL_PREDICTIVE"."ACCOUNT_REVENUE" (accountnr,location,total_amount) VALUES ('66802523699','Colombia',899);
INSERT INTO "TUTORIAL_PREDICTIVE"."ACCOUNT_REVENUE" (accountnr,location,total_amount) VALUES ('78554702399','Senegal',774);
INSERT INTO "TUTORIAL_PREDICTIVE"."ACCOUNT_REVENUE" (accountnr,location,total_amount) VALUES ('57575869099','Tunisia',26);
INSERT INTO "TUTORIAL_PREDICTIVE"."ACCOUNT_REVENUE" (accountnr,location,total_amount) VALUES ('09291636899','Burundi',655);
INSERT INTO "TUTORIAL_PREDICTIVE"."ACCOUNT_REVENUE" (accountnr,location,total_amount) VALUES ('68688029599','Argentina',790);
INSERT INTO "TUTORIAL_PREDICTIVE"."ACCOUNT_REVENUE" (accountnr,location,total_amount) VALUES ('54674462999','Zambia',684);
INSERT INTO "TUTORIAL_PREDICTIVE"."ACCOUNT_REVENUE" (accountnr,location,total_amount) VALUES ('07752768499','Bolivia',454);
INSERT INTO "TUTORIAL_PREDICTIVE"."ACCOUNT_REVENUE" (accountnr,location,total_amount) VALUES ('63610114499','Samoa',78);
INSERT INTO "TUTORIAL_PREDICTIVE"."ACCOUNT_REVENUE" (accountnr,location,total_amount) VALUES ('80322453199','Tajikistan',47);
INSERT INTO "TUTORIAL_PREDICTIVE"."ACCOUNT_REVENUE" (accountnr,location,total_amount) VALUES ('01611711299','Latvia',8213);
INSERT INTO "TUTORIAL_PREDICTIVE"."ACCOUNT_REVENUE" (accountnr,location,total_amount) VALUES ('05742930199','Curaçao',637);
INSERT INTO "TUTORIAL_PREDICTIVE"."ACCOUNT_REVENUE" (accountnr,location,total_amount) VALUES ('78351684399','United States Minor Outlying Islands',969);
INSERT INTO "TUTORIAL_PREDICTIVE"."ACCOUNT_REVENUE" (accountnr,location,total_amount) VALUES ('28553427199','Ethiopia',524);
INSERT INTO "TUTORIAL_PREDICTIVE"."ACCOUNT_REVENUE" (accountnr,location,total_amount) VALUES ('99534559099','Ukraine',4295);
INSERT INTO "TUTORIAL_PREDICTIVE"."ACCOUNT_REVENUE" (accountnr,location,total_amount) VALUES ('75215421499','Uganda',958);
INSERT INTO "TUTORIAL_PREDICTIVE"."ACCOUNT_REVENUE" (accountnr,location,total_amount) VALUES ('37984032999','Bermuda',193);
INSERT INTO "TUTORIAL_PREDICTIVE"."ACCOUNT_REVENUE" (accountnr,location,total_amount) VALUES ('20604544399','Tanzania',961);
INSERT INTO "TUTORIAL_PREDICTIVE"."ACCOUNT_REVENUE" (accountnr,location,total_amount) VALUES ('29957102299','Samoa',4);
INSERT INTO "TUTORIAL_PREDICTIVE"."ACCOUNT_REVENUE" (accountnr,location,total_amount) VALUES ('76457446499','Lebanon',72);
INSERT INTO "TUTORIAL_PREDICTIVE"."ACCOUNT_REVENUE" (accountnr,location,total_amount) VALUES ('67280243199','Antarctica',503);
INSERT INTO "TUTORIAL_PREDICTIVE"."ACCOUNT_REVENUE" (accountnr,location,total_amount) VALUES ('01625239599','Yemen',902);

MERGE DELTA OF "TUTORIAL_PREDICTIVE"."ACCOUNT_REVENUE";