create table total_population_by_ctr ( country varchar2(500 byte), year number, population number, avg_income number, avg_life_exp number, primary key (country, year) ); / insert into total_population_by_ctr values ('India',1970, 357561, 2000, 45 ); insert into total_population_by_ctr values ('India',1980, 708937, 2500, 50 ); insert into total_population_by_ctr values ('India',1990, 830484, 3000, 60 ); insert into total_population_by_ctr values ('India',2000, 951801, 4550, 63 ); insert into total_population_by_ctr values ('India',2010, 1072055, 5500, 67 ); -- insert into total_population_by_ctr values ('China', 1970, 854760, 1000, 45); insert into total_population_by_ctr values ('China', 1980, 1075133, 2000, 60); insert into total_population_by_ctr values ('China', 1990, 1110217, 4000, 65); insert into total_population_by_ctr values ('China', 2000, 1270787, 6000, 70); insert into total_population_by_ctr values ('China', 2010, 1462058, 8000, 73); -- insert into total_population_by_ctr values ('United States of America', 1970, 157813, 16000, 71); insert into total_population_by_ctr values ('United States of America', 1980, 283230, 19000, 75); insert into total_population_by_ctr values ('United States of America', 1990, 321225, 21000, 80); insert into total_population_by_ctr values ('United States of America', 2000, 346822, 28000, 82); insert into total_population_by_ctr values ('United States of America', 2010, 397063, 34000, 85); -- insert into total_population_by_ctr values ('Pakistan', 1970, 39659, 600, 47); insert into total_population_by_ctr values ('Pakistan', 1980, 141256, 1500, 55); insert into total_population_by_ctr values ('Pakistan', 1990, 204267, 2500, 61); insert into total_population_by_ctr values ('Pakistan', 2000, 250981, 3000, 62); insert into total_population_by_ctr values ('Pakistan', 2010, 344170, 2500, 64); -- insert into total_population_by_ctr values ('Brazil', 1970, 53975, 3000, 57); insert into total_population_by_ctr values ('Brazil', 1980, 170406, 7000, 58); insert into total_population_by_ctr values ('Brazil', 1990, 201393, 9000, 60); insert into total_population_by_ctr values ('Brazil', 2000, 218980, 11000, 66); insert into total_population_by_ctr values ('Brazil', 2010, 247244, 15000, 71); -- insert into total_population_by_ctr values ('Japan', 1970, 83625 ,15000, 65); insert into total_population_by_ctr values ('Japan', 1980, 127096 ,18000, 75); insert into total_population_by_ctr values ('Japan', 1990, 127522 ,24000, 80); insert into total_population_by_ctr values ('Japan', 2000, 123798 ,30000, 85); insert into total_population_by_ctr values ('Japan', 2010, 109220 ,36000, 87); -- insert into total_population_by_ctr values ('Russian Federation', 1970, 102702, 3500, 57); insert into total_population_by_ctr values ('Russian Federation', 1980, 145491, 6000, 60); insert into total_population_by_ctr values ('Russian Federation', 1990, 133314, 8000, 65); insert into total_population_by_ctr values ('Russian Federation', 2000, 125687, 9000, 70); insert into total_population_by_ctr values ('Russian Federation', 2010, 104258, 13000, 75); -- insert into total_population_by_ctr values ('Germany', 1970, 68376, 12000, 72); insert into total_population_by_ctr values ('Germany', 1980, 82017, 20000, 75); insert into total_population_by_ctr values ('Germany', 1990, 80673, 25500, 80); insert into total_population_by_ctr values ('Germany', 2000, 78897, 31000, 82); insert into total_population_by_ctr values ('Germany', 2010, 70805, 36000, 85); -- commit; /