Anonymous

INSERT INTO rank_table (name,min_points,max_points) VALUES ('(Elite) Master Sergeant','1001','1100');
INSERT INTO rank_table (name,min_points,max_points) VALUES ('(Elite) Lieutenant','1101','1200');
INSERT INTO rank_table (name,min_points,max_points) VALUES ('(Elite) Second lieutenant','1201','1300');
INSERT INTO rank_table (name,min_points,max_points) VALUES ('(Elite) First lieutenant','1301','1350');
INSERT INTO rank_table (name,min_points,max_points) VALUES ('(Elite) Captain','1351','1400');
INSERT INTO rank_table (name,min_points,max_points) VALUES ('(Elite) Major','1401','1450');
INSERT INTO rank_table (name,min_points,max_points) VALUES ('(Elite) Colonel','1451','1500');
INSERT INTO rank_table (name,min_points,max_points) VALUES ('(Elite) *General','1501','1600');
INSERT INTO rank_table (name,min_points,max_points) VALUES ('(Elite) **General','1601','1700');
INSERT INTO rank_table (name,min_points,max_points) VALUES ('(Elite) ***General','1701','1800');
INSERT INTO rank_table (name,min_points,max_points) VALUES ('(Elite) ****General','1801','1900');
INSERT INTO rank_table (name,min_points,max_points) VALUES ('(Elite) *****General','1901','2000');
INSERT INTO rank_table (name,min_points,max_points) VALUES ('(Veteran) Recruit','2001','2100');
INSERT INTO rank_table (name,min_points,max_points) VALUES ('(Veteran) Private','2101','2200');
INSERT INTO rank_table (name,min_points,max_points) VALUES ('(Veteran) Private First Class','2201','2300');
INSERT INTO rank_table (name,min_points,max_points) VALUES ('(Veteran) Corporal','2301','2400');
INSERT INTO rank_table (name,min_points,max_points) VALUES ('(Veteran) Sergeant','2401','2500');
INSERT INTO rank_table (name,min_points,max_points) VALUES ('(Veteran) Staff Sergeant','2501','2750');
INSERT INTO rank_table (name,min_points,max_points) VALUES ('(Veteran) Master Sergeant','2751','3000');
INSERT INTO rank_table (name,min_points,max_points) VALUES ('(Veteran) Lieutenant','3001','3250');
INSERT INTO rank_table (name,min_points,max_points) VALUES ('(Veteran) Second Lieutenant','3251','3500');
INSERT INTO rank_table (name,min_points,max_points) VALUES ('(Veteran) First Lieutenant','3501','3750');
INSERT INTO rank_table (name,min_points,max_points) VALUES ('(Veteran) captain','3751','4000');
INSERT INTO rank_table (name,min_points,max_points) VALUES ('(Veteran) Major','4001','4250');
INSERT INTO rank_table (name,min_points,max_points) VALUES ('(Veteran) Colonel','4251','5000');
INSERT INTO rank_table (name,min_points,max_points) VALUES ('(Veteran) *General','5001','5500');
INSERT INTO rank_table (name,min_points,max_points) VALUES ('(Veteran) **General','5501','6000');
INSERT INTO rank_table (name,min_points,max_points) VALUES ('(Veteran) ***General','6001','6500');
INSERT INTO rank_table (name,min_points,max_points) VALUES ('(Veteran) ****General','6501','7000');
INSERT INTO rank_table (name,min_points,max_points) VALUES ('(Veteran) *****General','7001','9999');
INSERT INTO rank_table (name,min_points,max_points) VALUES ('Commanding General Of The Armed Forces','10000','10005');
INSERT INTO rank_table (name,min_points,max_points) VALUES ('Commander In Chief','10006','900000');