insert into location values (1,'Chennai','Tamilnadu','India');
insert into location values (2,'Trichy','Tamilnadu','India');
insert into location values (3,'Madurai','Tamilnadu','India');
insert into location values (4,'Mumbai','Maharashtra','India');
insert into location values (5,'Pune','Maharashtra','India');
insert into location values (6,'Nasik','Maharashtra','India');
insert into location values (7,'Amritsar','Punjab','India');
insert into location values (8,'Ludhiana','Punjab','India');
insert into location values (9,'Patiala','Punjab','India');
--
insert into location values (10,'Calgary','Alberta','Canada');
insert into location values (11,'Edmonton','Alberta','Canada');
insert into location values (12,'FtMcMurray','Alberta','Canada');
insert into location values (13,'PrinceGeorge','BritishColumbia','Canada');
insert into location values (14,'Vancouver','BritishColumbia','Canada');
insert into location values (15,'Victoria','BritishColumbia','Canada');
insert into location values (16,'Winnipeg','Manitoba','Canada');
insert into location values (17,'Churchill','Manitoba','Canada');
insert into location values (18,'Thompson','Manitoba','Canada');
--
insert into location values (19,'Atlanta','Georgia','USA');
insert into location values (20,'Augusta','Georgia','USA');
insert into location values (21,'OklahomaCity','Oklahoma','USA');
insert into location values (22,'Norman','Oklahoma','USA');
insert into location values (23,'LosAngeles','California','USA');
insert into location values (24,'SanFrancisco','California','USA');
insert into location values (25,'SanJose','California','USA');
--
insert into location values (26,'Anqing','Anhui','China');
insert into location values (27,'Hefei','Anhui','China');
insert into location values (28,'Huangshan','Anhui','China');
insert into location values (29,'Guangzhou','Guangdong','China');
insert into location values (30,'Shenzhen','Guangdong','China');
insert into location values (31,'Foshan','Guangdong','China');
insert into location values (32,'Shijiazhuang','Hebei','China');
insert into location values (33,'Zhangjiakou','Hebei','China');
insert into location values (34,'Qinhuangdao','Hebei','China');
