***PRESET SCRIPTS***

----------------------------------------------------------------------------------------------

DROP TABLE IF EXISTS school_probs;

---------------------------------------------------------------------------------------------

CREATE TABLE school_probs ( school_code bigint NOT NULL PRIMARY KEY, school text NOT NULL, probs numeric[] NOT NULL );

--------------------------------------------------------------------------------

INSERT INTO school_probs VALUES (1,'CAA','{0.05,0.08,0.18,0.3,0.11,0.28}'), (2,'CAS','{0.06,0.1,0.295,0.36,0.12,0.065}'), (3,'CBA','{0.05,0.11,0.35,0.32,0.12,0.05}'), (4,'CE','{0.04,0.05,0.08,0.3,0.42,0.11}'), (5,'CEC','{0.05,0.11,0.35,0.32,0.12,0.05}'), (6,'HC','{0.12,0.1,0.23,0.4,0.06,0.09}'), (7,'CL','{0.07,0.09,0.24,0.4,0.12,0.08}'), (8,'CNHS','{0.08,0.1,0.295,0.34,0.12,0.065}'), (9,'SJMC','{0.09,0.11,0.31,0.32,0.12,0.05}');

--------------------------------------------------------------------------------

DROP TABLE IF EXISTS grade_values;

-----------------------------------------------------------------------------

CREATE TABLE grade_values ( id integer NOT NULL PRIMARY KEY, score text NOT NULL, grade text NOT NULL );

----------------------------------------------------------------

INSERT INTO grade_values VALUES (1,'95 - 100','A'), (2,'90 - 94','A-'), (3,'80 - 89','B+'), (4,'70 - 79','B'), (5,'60 - 69','C'), (6,'0 - 59','D');

--------------------------------------------------------------------------------------

DROP TABLE IF EXISTS simulated_records;

-------------------------------------------------------------------------------------

CREATE TABLE simulated_records ( record_id bigint NOT NULL PRIMARY KEY, school text NOT NULL, grade text NOT NULL )

------------------------------------------------------------------------;

INSERT INTO simulated_records VALUES (1,'CL','-'), (2,'CEC','-'), (3,'CEC','-'), (4,'CEC','-'), (5,'CAA','-'), (6,'CAS','-'), (7,'CAA','-'), (8,'CAA','-'), (9,'CAA','-'), (10,'CL','-'), (11,'CBA','-'), (12,'CAA','-'), (13,'HC','-'), (14,'CL','-'), (15,'CNHS','-'), (16,'CBA','-'), (17,'CE','-'), (18,'CE','-'), (19,'HC','-'), (20,'CNHS','-'), (21,'SJMC','-'), (22,'CAA','-'), (23,'CBA','-'), (24,'CE','-'), (25,'CBA','-'), (26,'SJMC','-'), (27,'CAS','-'), (28,'CAS','-'), (29,'HC','-'), (30,'CEC','-'), (31,'CE','-'), (32,'CNHS','-'), (33,'CNHS','-'), (34,'CAA','-'), (35,'CBA','-'), (36,'CNHS','-'), (37,'HC','-'), (38,'CAS','-'), (39,'HC','-'), (40,'CBA','-'), (41,'CAA','-'), (42,'SJMC','-'), (43,'HC','-'), (44,'CBA','-'), (45,'CAS','-'), (46,'CBA','-'), (47,'CAA','-'), (48,'CL','-'), (49,'CAS','-'), (50,'CNHS','-'), (51,'CBA','-'), (52,'CE','-'), (53,'CAA','-'), (54,'CAS','-'), (55,'CBA','-'), (56,'CAA','-'), (57,'CBA','-'), (58,'CAA','-'), (59,'CAA','-'), (60,'SJMC','-'), (61,'CBA','-'), (62,'HC','-'), (63,'CE','-'), (64,'CL','-'), (65,'SJMC','-'), (66,'HC','-'), (67,'CL','-'), (68,'CE','-'), (69,'CAS','-'), (70,'CAA','-'), (71,'CAS','-'), (72,'SJMC','-'), (73,'SJMC','-'), (74,'CEC','-'), (75,'CNHS','-'), (76,'CE','-'), (77,'CBA','-'), (78,'CNHS','-'), (79,'CE','-'), (80,'HC','-'), (81,'SJMC','-'), (82,'CNHS','-'), (83,'CAS','-'), (84,'CE','-'), (85,'CNHS','-'), (86,'CAS','-'), (87,'CNHS','-'), (88,'SJMC','-'), (89,'CEC','-'), (90,'HC','-'), (91,'SJMC','-'), (92,'CNHS','-'), (93,'CE','-'), (94,'CEC','-'), (95,'CBA','-'), (96,'CEC','-'), (97,'CAA','-'), (98,'CAA','-'), (99,'HC','-'), (100,'HC','-'), (101,'CAA','-'), (102,'HC','-'), (103,'CEC','-'), (104,'SJMC','-'), (105,'HC','-'), (106,'CBA','-'), (107,'CAA','-'), (108,'CAA','-'), (109,'HC','-'), (110,'CL','-'), (111,'CBA','-'), (112,'CE','-'), (113,'CE','-'), (114,'CAA','-'), (115,'CAA','-'), (116,'CAA','-'), (117,'CL','-'), (118,'CAS','-'), (119,'CAS','-'), (120,'CL','-'), (121,'HC','-'), (122,'HC','-'), (123,'CL','-'), (124,'CNHS','-'), (125,'CE','-'), (126,'CAA','-'), (127,'CAS','-'), (128,'CL','-'), (129,'CL','-'), (130,'CAA','-'), (131,'CE','-'), (132,'CEC','-'), (133,'CNHS','-'), (134,'CAA','-'), (135,'CEC','-'), (136,'CAA','-'), (137,'CNHS','-'), (138,'CE','-'), (139,'CAS','-'), (140,'CAA','-'), (141,'CAA','-'), (142,'SJMC','-'), (143,'CAS','-'), (144,'CBA','-'), (145,'CBA','-'), (146,'CAA','-'), (147,'HC','-'), (148,'HC','-'), (149,'SJMC','-'), (150,'CAS','-'), (151,'CNHS','-'), (152,'CBA','-'), (153,'CNHS','-'), (154,'CL','-'), (155,'CAS','-'), (156,'CAS','-'), (157,'CEC','-'), (158,'CAA','-'), (159,'SJMC','-'), (160,'SJMC','-'), (161,'CBA','-'), (162,'CEC','-'), (163,'CBA','-'), (164,'CEC','-'), (165,'CBA','-'), (166,'CL','-'), (167,'SJMC','-'), (168,'HC','-'), (169,'CBA','-'), (170,'SJMC','-'), (171,'CAA','-'), (172,'HC','-'), (173,'SJMC','-'), (174,'CEC','-'), (175,'CBA','-'), (176,'CEC','-'), (177,'SJMC','-'), (178,'CAS','-'), (179,'CNHS','-'), (180,'CAA','-'), (181,'CE','-'), (182,'SJMC','-'), (183,'CL','-'), (184,'CEC','-'), (185,'HC','-'), (186,'CAA','-'), (187,'CAS','-'), (188,'CNHS','-'), (189,'HC','-'), (190,'CAA','-'), (191,'HC','-'), (192,'HC','-'), (193,'CL','-'), (194,'CBA','-'), (195,'SJMC','-'), (196,'CNHS','-'), (197,'CAA','-'), (198,'CBA','-'), (199,'SJMC','-'), (200,'CAA','-'), (201,'CNHS','-'), (202,'CAA','-'), (203,'CNHS','-'), (204,'CL','-'), (205,'CNHS','-'), (206,'SJMC','-'), (207,'CAS','-'), (208,'CNHS','-'), (209,'CEC','-'), (210,'CAA','-'), (211,'CAA','-'), (212,'CAA','-'), (213,'CAS','-'), (214,'CBA','-'), (215,'HC','-'), (216,'SJMC','-'), (217,'CAS','-'), (218,'CL','-'), (219,'CE','-'), (220,'CBA','-'), (221,'CL','-'), (222,'CE','-'), (223,'CAA','-'), (224,'CEC','-'), (225,'CEC','-'), (226,'CBA','-'), (227,'CAS','-'), (228,'SJMC','-'), (229,'CBA','-'), (230,'CEC','-'), (231,'HC','-'), (232,'CBA','-'), (233,'CBA','-'), (234,'CBA','-'), (235,'HC','-'), (236,'CE','-'), (237,'CAS','-'), (238,'CL','-'), (239,'CBA','-'), (240,'CEC','-'), (241,'CE','-'), (242,'HC','-'), (243,'HC','-'), (244,'CNHS','-'), (245,'SJMC','-'), (246,'CAS','-'), (247,'CAA','-'), (248,'CBA','-'), (249,'HC','-'), (250,'CE','-'), (251,'SJMC','-'), (252,'CAA','-'), (253,'CL','-'), (254,'HC','-'), (255,'CAA','-'), (256,'HC','-'), (257,'CL','-'), (258,'CAS','-'), (259,'CBA','-'), (260,'CAS','-'), (261,'CNHS','-'), (262,'CBA','-'), (263,'CBA','-'), (264,'CAA','-'), (265,'HC','-'), (266,'HC','-'), (267,'SJMC','-'), (268,'SJMC','-'), (269,'CAA','-'), (270,'CNHS','-'), (271,'SJMC','-'), (272,'CEC','-'), (273,'CAA','-'), (274,'CAA','-'), (275,'CAS','-'), (276,'CNHS','-'), (277,'CE','-'), (278,'CNHS','-'), (279,'CAA','-'), (280,'CL','-'), (281,'CAA','-'), (282,'CNHS','-'), (283,'CEC','-'), (284,'CAA','-'), (285,'SJMC','-'), (286,'CE','-'), (287,'CAA','-'), (288,'HC','-'), (289,'CE','-'), (290,'HC','-'), (291,'CBA','-'), (292,'CAS','-'), (293,'CAS','-'), (294,'CE','-'), (295,'SJMC','-'), (296,'CE','-'), (297,'HC','-'), (298,'CE','-'), (299,'CNHS','-'), (300,'CNHS','-'), (301,'CAA','-'), (302,'CAA','-'), (303,'CL','-'), (304,'CE','-'), (305,'CAA','-'), (306,'HC','-'), (307,'HC','-'), (308,'SJMC','-'), (309,'HC','-'), (310,'CEC','-'), (311,'HC','-'), (312,'CEC','-'), (313,'CBA','-'), (314,'SJMC','-'), (315,'CL','-'), (316,'CL','-'), (317,'CL','-'), (318,'CE','-'), (319,'CE','-'), (320,'CAS','-'), (321,'SJMC','-'), (322,'SJMC','-'), (323,'SJMC','-'), (324,'CAA','-'), (325,'CAA','-'), (326,'CAS','-'), (327,'CEC','-'), (328,'CAA','-'), (329,'CAA','-'), (330,'HC','-'), (331,'CAA','-'), (332,'CL','-'), (333,'HC','-'), (334,'CAA','-'), (335,'CAS','-'), (336,'CE','-'), (337,'CAA','-'), (338,'CL','-'), (339,'CE','-'), (340,'CL','-'), (341,'SJMC','-'), (342,'CAA','-'), (343,'CNHS','-'), (344,'CBA','-'), (345,'CEC','-'), (346,'SJMC','-'), (347,'CNHS','-'), (348,'CE','-'), (349,'CL','-'), (350,'CEC','-'), (351,'CE','-'), (352,'SJMC','-'), (353,'HC','-'), (354,'CNHS','-'), (355,'CL','-'), (356,'CAA','-'), (357,'CL','-'), (358,'CE','-'), (359,'CAA','-'), (360,'HC','-'), (361,'CEC','-'), (362,'CAA','-'), (363,'CEC','-'), (364,'CBA','-'), (365,'SJMC','-'), (366,'CAS','-'), (367,'SJMC','-'), (368,'CAS','-'), (369,'CBA','-'), (370,'CBA','-'), (371,'CNHS','-'), (372,'HC','-'), (373,'CNHS','-'), (374,'CAA','-'), (375,'CAS','-'), (376,'HC','-'), (377,'CAA','-'), (378,'CL','-'), (379,'HC','-'), (380,'CNHS','-'), (381,'CAS','-'), (382,'CL','-'), (383,'CNHS','-'), (384,'SJMC','-'), (385,'CE','-'), (386,'CAS','-'), (387,'CBA','-'), (388,'CBA','-'), (389,'CE','-'), (390,'CE','-'), (391,'HC','-'), (392,'SJMC','-'), (393,'CBA','-'), (394,'CAS','-'), (395,'SJMC','-'), (396,'SJMC','-'), (397,'CBA','-'), (398,'CAA','-'), (399,'CNHS','-'), (400,'CAA','-'), (401,'CEC','-'), (402,'CE','-'), (403,'HC','-'), (404,'CAA','-'), (405,'HC','-'), (406,'CAA','-'), (407,'CAA','-'), (408,'CE','-'), (409,'CBA','-'), (410,'SJMC','-'), (411,'CEC','-'), (412,'CE','-'), (413,'CBA','-'), (414,'CEC','-'), (415,'CNHS','-'), (416,'CAS','-'), (417,'CL','-'), (418,'HC','-'), (419,'CE','-'), (420,'SJMC','-'), (421,'CEC','-'), (422,'SJMC','-'), (423,'CEC','-'), (424,'SJMC','-'), (425,'CL','-'), (426,'CL','-'), (427,'CEC','-'), (428,'CE','-'), (429,'HC','-'), (430,'CEC','-'), (431,'CAS','-'), (432,'HC','-'), (433,'SJMC','-'), (434,'CAA','-'), (435,'CNHS','-'), (436,'CAA','-'), (437,'CBA','-'), (438,'SJMC','-'), (439,'HC','-'), (440,'CBA','-'), (441,'CAS','-'), (442,'CBA','-'), (443,'CNHS','-'), (444,'CNHS','-'), (445,'CL','-'), (446,'CNHS','-'), (447,'CNHS','-'), (448,'CAA','-'), (449,'CE','-'), (450,'CAS','-'), (451,'CAS','-'), (452,'CEC','-'), (453,'CE','-'), (454,'HC','-'), (455,'CBA','-'), (456,'HC','-'), (457,'HC','-'), (458,'CAA','-'), (459,'CAA','-'), (460,'CAS','-'), (461,'CEC','-'), (462,'CNHS','-'), (463,'CBA','-'), (464,'CAS','-'), (465,'CAA','-'), (466,'SJMC','-'), (467,'CAS','-'), (468,'HC','-'), (469,'CAS','-'), (470,'CAS','-'), (471,'CL','-'), (472,'CAS','-'), (473,'CNHS','-'), (474,'CAA','-'), (475,'CL','-'), (476,'CBA','-'), (477,'SJMC','-'), (478,'CNHS','-'), (479,'SJMC','-'), (480,'HC','-'), (481,'CL','-'), (482,'CEC','-'), (483,'CNHS','-'), (484,'CAS','-'), (485,'CAA','-'), (486,'CAS','-'), (487,'SJMC','-'), (488,'CNHS','-'), (489,'CAA','-'), (490,'CL','-'), (491,'CAA','-'), (492,'CAS','-'), (493,'HC','-'), (494,'SJMC','-'), (495,'SJMC','-'), (496,'CEC','-'), (497,'CNHS','-'), (498,'CBA','-'), (499,'CAA','-'), (500,'CBA','-'), (501,'CBA','-'), (502,'CAS','-'), (503,'CNHS','-'), (504,'CE','-'), (505,'CAS','-'), (506,'CAS','-'), (507,'SJMC','-'), (508,'SJMC','-'), (509,'CEC','-'), (510,'CE','-'), (511,'CAA','-'), (512,'CBA','-'), (513,'SJMC','-'), (514,'SJMC','-'), (515,'CNHS','-'), (516,'SJMC','-'), (517,'CAA','-'), (518,'CBA','-'), (519,'CEC','-'), (520,'HC','-'), (521,'CBA','-'), (522,'CAA','-'), (523,'CAS','-'), (524,'CBA','-'), (525,'CE','-'), (526,'CE','-'), (527,'CE','-'), (528,'HC','-'), (529,'CE','-'), (530,'CE','-'), (531,'CEC','-'), (532,'SJMC','-'), (533,'CBA','-'), (534,'CBA','-'), (535,'SJMC','-'), (536,'CNHS','-'), (537,'CE','-'), (538,'SJMC','-'), (539,'CE','-'), (540,'CEC','-'), (541,'CE','-'), (542,'CEC','-'), (543,'CL','-'), (544,'CAA','-'), (545,'CL','-'), (546,'CAA','-'), (547,'CEC','-'), (548,'CBA','-'), (549,'HC','-'), (550,'CAS','-'), (551,'CAA','-'), (552,'CAS','-'), (553,'HC','-'), (554,'CBA','-'), (555,'CAA','-'), (556,'CAS','-'), (557,'CBA','-'), (558,'CAS','-'), (559,'CL','-'), (560,'CAA','-'), (561,'CBA','-'), (562,'CAS','-'), (563,'CL','-'), (564,'CL','-'), (565,'SJMC','-'), (566,'HC','-'), (567,'HC','-'), (568,'CEC','-'), (569,'SJMC','-'), (570,'CE','-'), (571,'CE','-'), (572,'HC','-'), (573,'CBA','-'), (574,'CAA','-'), (575,'CE','-'), (576,'CAS','-'), (577,'HC','-'), (578,'CNHS','-'), (579,'CE','-'), (580,'HC','-'), (581,'CBA','-'), (582,'CEC','-'), (583,'CBA','-'), (584,'CNHS','-'), (585,'CL','-'), (586,'CAA','-'), (587,'CAA','-'), (588,'CEC','-'), (589,'CL','-'), (590,'CNHS','-'), (591,'CL','-'), (592,'SJMC','-'), (593,'CAS','-'), (594,'CAS','-'), (595,'SJMC','-'), (596,'CEC','-'), (597,'CAS','-'), (598,'CL','-'), (599,'SJMC','-'), (600,'CNHS','-'), (601,'CNHS','-'), (602,'CEC','-'), (603,'CAS','-'), (604,'CEC','-'), (605,'CNHS','-'), (606,'CAS','-'), (607,'CL','-'), (608,'SJMC','-'), (609,'CEC','-'), (610,'CEC','-'), (611,'SJMC','-'), (612,'HC','-'), (613,'CNHS','-'), (614,'CE','-'), (615,'CBA','-'), (616,'CE','-'), (617,'CL','-'), (618,'CAS','-'), (619,'CEC','-'), (620,'CAA','-'), (621,'CAA','-'), (622,'SJMC','-'), (623,'HC','-'), (624,'CE','-'), (625,'CL','-'), (626,'CEC','-'), (627,'CL','-'), (628,'CNHS','-'), (629,'HC','-'), (630,'CEC','-'), (631,'CEC','-'), (632,'CAA','-'), (633,'SJMC','-'), (634,'CE','-'), (635,'CE','-'), (636,'CEC','-'), (637,'CBA','-'), (638,'CL','-'), (639,'CAA','-'), (640,'CNHS','-'), (641,'CNHS','-'), (642,'CEC','-'), (643,'CAS','-'), (644,'SJMC','-'), (645,'CAS','-'), (646,'HC','-'), (647,'HC','-'), (648,'CEC','-'), (649,'HC','-'), (650,'CL','-'), (651,'CE','-'), (652,'HC','-'), (653,'CE','-'), (654,'CAA','-'), (655,'CBA','-'), (656,'CEC','-'), (657,'CAA','-'), (658,'CAA','-'), (659,'CBA','-'), (660,'CL','-'), (661,'CEC','-'), (662,'CEC','-'), (663,'CAA','-'), (664,'CAA','-'), (665,'CBA','-'), (666,'CBA','-'), (667,'CNHS','-'), (668,'HC','-'), (669,'SJMC','-'), (670,'CEC','-'), (671,'CE','-'), (672,'SJMC','-'), (673,'CAS','-'), (674,'CAS','-'), (675,'CL','-'), (676,'CBA','-'), (677,'CAS','-'), (678,'CBA','-'), (679,'CBA','-'), (680,'CAS','-'), (681,'CL','-'), (682,'CBA','-'), (683,'HC','-'), (684,'CEC','-'), (685,'CBA','-'), (686,'HC','-'), (687,'CEC','-'), (688,'CAA','-'), (689,'HC','-'), (690,'CAA','-'), (691,'CBA','-'), (692,'CEC','-'), (693,'CNHS','-'), (694,'CL','-'), (695,'CEC','-'), (696,'SJMC','-'), (697,'CEC','-'), (698,'CBA','-'), (699,'SJMC','-'), (700,'CEC','-'), (701,'SJMC','-'), (702,'CAS','-'), (703,'CAA','-'), (704,'CAA','-'), (705,'HC','-'), (706,'CEC','-'), (707,'CE','-'), (708,'CNHS','-'), (709,'CEC','-'), (710,'CL','-'), (711,'SJMC','-'), (712,'CNHS','-'), (713,'SJMC','-'), (714,'HC','-'), (715,'CE','-'), (716,'CE','-'), (717,'CEC','-'), (718,'HC','-'), (719,'SJMC','-'), (720,'CEC','-'), (721,'SJMC','-'), (722,'CE','-'), (723,'CBA','-'), (724,'CBA','-'), (725,'CEC','-'), (726,'CEC','-'), (727,'CL','-'), (728,'CE','-'), (729,'SJMC','-'), (730,'CBA','-'), (731,'CL','-'), (732,'SJMC','-'), (733,'HC','-'), (734,'SJMC','-'), (735,'CAA','-'), (736,'HC','-'), (737,'CAS','-'), (738,'CE','-'), (739,'CAS','-'), (740,'CEC','-'), (741,'CBA','-'), (742,'CL','-'), (743,'HC','-'), (744,'CAS','-'), (745,'CAA','-'), (746,'CAS','-'), (747,'CEC','-'), (748,'HC','-'), (749,'CAA','-'), (750,'CAA','-'), (751,'CBA','-'), (752,'CAA','-'), (753,'CE','-'), (754,'CBA','-'), (755,'HC','-'), (756,'CAS','-'), (757,'CL','-'), (758,'CAS','-'), (759,'CAA','-'), (760,'SJMC','-'), (761,'HC','-'), (762,'CE','-'), (763,'CAA','-'), (764,'HC','-'), (765,'CAA','-'), (766,'CAS','-'), (767,'CAA','-'), (768,'CBA','-'), (769,'CBA','-'), (770,'SJMC','-'), (771,'SJMC','-'), (772,'CNHS','-'), (773,'CAA','-'), (774,'CE','-'), (775,'CE','-'), (776,'CE','-'), (777,'CAS','-'), (778,'CAA','-'), (779,'CNHS','-'), (780,'CNHS','-'), (781,'CNHS','-'), (782,'HC','-'), (783,'HC','-'), (784,'CEC','-'), (785,'CBA','-'), (786,'CAS','-'), (787,'CEC','-'), (788,'CL','-'), (789,'CBA','-'), (790,'CAS','-'), (791,'CBA','-'), (792,'CAA','-'), (793,'HC','-'), (794,'CE','-'), (795,'SJMC','-'), (796,'CE','-'), (797,'SJMC','-'), (798,'CAS','-'), (799,'CNHS','-'), (800,'SJMC','-'), (801,'CE','-'), (802,'HC','-'), (803,'CAA','-'), (804,'CBA','-'), (805,'HC','-'), (806,'CEC','-'), (807,'SJMC','-'), (808,'CL','-'), (809,'CEC','-'), (810,'HC','-'), (811,'CAA','-'), (812,'CNHS','-'), (813,'CBA','-'), (814,'CAA','-'), (815,'SJMC','-'), (816,'CAA','-'), (817,'CAA','-'), (818,'HC','-'), (819,'CE','-'), (820,'CAS','-'), (821,'CAA','-'), (822,'HC','-'), (823,'CEC','-'), (824,'CAA','-'), (825,'CE','-'), (826,'SJMC','-'), (827,'HC','-'), (828,'CL','-'), (829,'HC','-'), (830,'CEC','-'), (831,'CEC','-'), (832,'HC','-'), (833,'CNHS','-'), (834,'HC','-'), (835,'CL','-'), (836,'CE','-'), (837,'HC','-'), (838,'CAS','-'), (839,'SJMC','-'), (840,'CBA','-'), (841,'CE','-'), (842,'CBA','-'), (843,'CAS','-'), (844,'CAA','-'), (845,'CL','-'), (846,'CAA','-'), (847,'CAS','-'), (848,'HC','-'), (849,'CL','-'), (850,'SJMC','-'), (851,'HC','-'), (852,'SJMC','-'), (853,'CL','-'), (854,'CNHS','-'), (855,'CEC','-'), (856,'CAS','-'), (857,'CE','-'), (858,'HC','-'), (859,'CE','-'), (860,'HC','-'), (861,'HC','-'), (862,'CNHS','-'), (863,'CAS','-'), (864,'CEC','-'), (865,'CE','-'), (866,'SJMC','-'), (867,'SJMC','-'), (868,'CE','-'), (869,'CNHS','-'), (870,'SJMC','-'), (871,'CE','-'), (872,'CAA','-'), (873,'CEC','-'), (874,'CBA','-'), (875,'CNHS','-'), (876,'CAS','-'), (877,'CAS','-'), (878,'CEC','-'), (879,'CAA','-'), (880,'CAS','-'), (881,'HC','-'), (882,'CAA','-'), (883,'HC','-'), (884,'SJMC','-'), (885,'CEC','-'), (886,'CBA','-'), (887,'CNHS','-'), (888,'HC','-'), (889,'CEC','-'), (890,'CE','-'), (891,'CAS','-'), (892,'CE','-'), (893,'CEC','-'), (894,'SJMC','-'), (895,'CL','-'), (896,'HC','-'), (897,'CAA','-'), (898,'CAA','-'), (899,'HC','-'), (900,'CEC','-'), (901,'CEC','-'), (902,'HC','-'), (903,'HC','-'), (904,'CEC','-'), (905,'CAS','-'), (906,'CNHS','-'), (907,'CNHS','-'), (908,'CBA','-'), (909,'CEC','-'), (910,'CAS','-'), (911,'CAS','-'), (912,'CNHS','-'), (913,'CAA','-'), (914,'CAS','-'), (915,'HC','-'), (916,'HC','-'), (917,'CAA','-'), (918,'SJMC','-'), (919,'SJMC','-'), (920,'CAS','-'), (921,'CAS','-'), (922,'HC','-'), (923,'CAS','-'), (924,'CAA','-'), (925,'CE','-'), (926,'CE','-'), (927,'CAA','-'), (928,'CL','-'), (929,'CEC','-'), (930,'CAS','-'), (931,'SJMC','-'), (932,'CL','-'), (933,'CL','-'), (934,'CE','-'), (935,'CEC','-'), (936,'CAA','-'), (937,'SJMC','-'), (938,'CE','-'), (939,'CL','-'), (940,'CL','-'), (941,'CBA','-'), (942,'HC','-'), (943,'CE','-'), (944,'CNHS','-'), (945,'CAA','-'), (946,'CNHS','-'), (947,'SJMC','-'), (948,'SJMC','-'), (949,'CL','-'), (950,'SJMC','-'), (951,'CEC','-'), (952,'CE','-'), (953,'CAA','-'), (954,'SJMC','-'), (955,'CL','-'), (956,'CL','-'), (957,'CE','-'), (958,'CEC','-'), (959,'CE','-'), (960,'CEC','-'), (961,'CE','-'), (962,'CAA','-'), (963,'HC','-'), (964,'HC','-'), (965,'CL','-'), (966,'CBA','-'), (967,'CL','-'), (968,'CL','-'), (969,'CEC','-'), (970,'SJMC','-'), (971,'CNHS','-'), (972,'CEC','-'), (973,'CNHS','-'), (974,'CL','-'), (975,'CAA','-'), (976,'SJMC','-'), (977,'HC','-'), (978,'CAA','-'), (979,'CNHS','-'), (980,'CAA','-'), (981,'CBA','-'), (982,'CE','-'), (983,'HC','-'), (984,'SJMC','-'), (985,'CE','-'), (986,'CL','-'), (987,'CE','-'), (988,'HC','-'), (989,'SJMC','-'), (990,'SJMC','-'), (991,'CAA','-'), (992,'CAS','-'), (993,'HC','-'), (994,'CNHS','-'), (995,'CAS','-'), (996,'CE','-'), (997,'CBA','-'), (998,'CEC','-'), (999,'CAS','-'), (1000,'CL','-'), (1001,'CAA','-'), (1002,'SJMC','-'), (1003,'CAA','-'), (1004,'CNHS','-'), (1005,'CNHS','-'), (1006,'CEC','-'), (1007,'HC','-'), (1008,'CE','-'), (1009,'CNHS','-'), (1010,'HC','-'), (1011,'HC','-'), (1012,'CNHS','-'), (1013,'CEC','-'), (1014,'SJMC','-'), (1015,'CEC','-'), (1016,'HC','-'), (1017,'HC','-'), (1018,'CL','-'), (1019,'CEC','-'), (1020,'CNHS','-'), (1021,'CE','-'), (1022,'SJMC','-'), (1023,'CAA','-'), (1024,'CL','-'), (1025,'HC','-'), (1026,'CAA','-'), (1027,'CNHS','-'), (1028,'CL','-'), (1029,'CE','-'), (1030,'CBA','-'), (1031,'CBA','-'), (1032,'HC','-'), (1033,'CL','-'), (1034,'SJMC','-'), (1035,'CAS','-'), (1036,'CEC','-'), (1037,'CE','-'), (1038,'CAS','-'), (1039,'CNHS','-'), (1040,'CNHS','-'), (1041,'CE','-'), (1042,'CBA','-'), (1043,'CEC','-'), (1044,'CBA','-'), (1045,'CAS','-'), (1046,'CE','-'), (1047,'CBA','-'), (1048,'CAS','-'), (1049,'HC','-'), (1050,'CAS','-'), (1051,'SJMC','-'), (1052,'HC','-'), (1053,'CAS','-'), (1054,'CL','-'), (1055,'CL','-'), (1056,'CBA','-'), (1057,'CEC','-'), (1058,'CNHS','-'), (1059,'CAA','-'), (1060,'CL','-'), (1061,'CNHS','-'), (1062,'CNHS','-'), (1063,'CL','-'), (1064,'SJMC','-'), (1065,'CBA','-'), (1066,'HC','-'), (1067,'CL','-'), (1068,'SJMC','-'), (1069,'CAS','-'), (1070,'CAS','-'), (1071,'SJMC','-'), (1072,'CAS','-'), (1073,'CAA','-'), (1074,'CBA','-'), (1075,'CEC','-'), (1076,'CNHS','-'), (1077,'HC','-'), (1078,'CBA','-'), (1079,'CE','-'), (1080,'CNHS','-'), (1081,'HC','-'), (1082,'CBA','-'), (1083,'CEC','-'), (1084,'SJMC','-'), (1085,'CAS','-'), (1086,'CNHS','-'), (1087,'CAS','-'), (1088,'CAA','-'), (1089,'SJMC','-'), (1090,'CL','-'), (1091,'CAS','-'), (1092,'CAA','-'), (1093,'CE','-'), (1094,'CL','-'), (1095,'HC','-'), (1096,'CEC','-'), (1097,'SJMC','-'), (1098,'CEC','-'), (1099,'CAA','-'), (1100,'CEC','-'), (1101,'HC','-'), (1102,'HC','-'), (1103,'CAS','-'), (1104,'CBA','-'), (1105,'CBA','-'), (1106,'HC','-'), (1107,'HC','-'), (1108,'CL','-'), (1109,'CAS','-'), (1110,'CL','-'), (1111,'CNHS','-'), (1112,'CE','-'), (1113,'CE','-'), (1114,'CL','-'), (1115,'CAS','-'), (1116,'SJMC','-'), (1117,'CAA','-'), (1118,'CEC','-'), (1119,'CBA','-'), (1120,'CBA','-'), (1121,'SJMC','-'), (1122,'CAS','-'), (1123,'CEC','-'), (1124,'CE','-'), (1125,'CNHS','-'), (1126,'CNHS','-'), (1127,'CEC','-'), (1128,'CEC','-'), (1129,'CE','-'), (1130,'CEC','-'), (1131,'CL','-'), (1132,'CEC','-'), (1133,'CL','-'), (1134,'SJMC','-'), (1135,'CNHS','-'), (1136,'CE','-'), (1137,'CAA','-'), (1138,'SJMC','-'), (1139,'CE','-'), (1140,'CNHS','-'), (1141,'CNHS','-'), (1142,'CNHS','-'), (1143,'HC','-'), (1144,'CBA','-'), (1145,'CL','-'), (1146,'CEC','-'), (1147,'CEC','-'), (1148,'CEC','-'), (1149,'CE','-'), (1150,'CAS','-'), (1151,'CBA','-'), (1152,'SJMC','-'), (1153,'SJMC','-'), (1154,'CEC','-'), (1155,'HC','-'), (1156,'CL','-'), (1157,'CAA','-'), (1158,'HC','-'), (1159,'CAS','-'), (1160,'CAA','-'), (1161,'CAA','-'), (1162,'SJMC','-'), (1163,'CEC','-'), (1164,'CAS','-'), (1165,'HC','-'), (1166,'HC','-'), (1167,'CBA','-'), (1168,'CL','-'), (1169,'CE','-'), (1170,'CAS','-'), (1171,'CAS','-'), (1172,'CE','-'), (1173,'CBA','-'), (1174,'HC','-'), (1175,'HC','-'), (1176,'CAA','-'), (1177,'HC','-'), (1178,'CEC','-'), (1179,'CL','-'), (1180,'CNHS','-'), (1181,'CAS','-'), (1182,'CEC','-'), (1183,'SJMC','-'), (1184,'HC','-'), (1185,'CAS','-'), (1186,'CAA','-'), (1187,'CAS','-'), (1188,'CEC','-'), (1189,'CAA','-'), (1190,'CAA','-'), (1191,'HC','-'), (1192,'CAS','-'), (1193,'CAS','-'), (1194,'CAS','-'), (1195,'CAA','-'), (1196,'CL','-'), (1197,'CE','-'), (1198,'CEC','-'), (1199,'HC','-'), (1200,'SJMC','-'), (1201,'CAA','-'), (1202,'CBA','-'), (1203,'CAA','-'), (1204,'CAA','-'), (1205,'CAA','-'), (1206,'CAS','-'), (1207,'CNHS','-'), (1208,'SJMC','-'), (1209,'CEC','-'), (1210,'CNHS','-'), (1211,'CAS','-'), (1212,'CE','-'), (1213,'CE','-'), (1214,'CL','-'), (1215,'SJMC','-'), (1216,'CAS','-'), (1217,'CNHS','-'), (1218,'CEC','-'), (1219,'CNHS','-'), (1220,'SJMC','-'), (1221,'CAS','-'), (1222,'SJMC','-'), (1223,'HC','-'), (1224,'SJMC','-'), (1225,'CAS','-'), (1226,'CE','-'), (1227,'CBA','-'), (1228,'HC','-'), (1229,'CNHS','-'), (1230,'CE','-'), (1231,'HC','-'), (1232,'CNHS','-'), (1233,'CNHS','-'), (1234,'CAS','-'), (1235,'CL','-'), (1236,'CL','-'), (1237,'CNHS','-'), (1238,'CL','-'), (1239,'CBA','-'), (1240,'CAA','-'), (1241,'CBA','-'), (1242,'CNHS','-'), (1243,'SJMC','-'), (1244,'CE','-'), (1245,'SJMC','-'), (1246,'CEC','-'), (1247,'SJMC','-'), (1248,'CAS','-'), (1249,'CE','-'), (1250,'CAA','-'), (1251,'CE','-'), (1252,'CE','-'), (1253,'CBA','-'), (1254,'SJMC','-'), (1255,'CEC','-'), (1256,'CL','-'), (1257,'CL','-'), (1258,'CNHS','-'), (1259,'CBA','-'), (1260,'CNHS','-'), (1261,'CE','-'), (1262,'CAA','-'), (1263,'SJMC','-'), (1264,'CAA','-'), (1265,'CEC','-'), (1266,'CNHS','-'), (1267,'CAA','-'), (1268,'CE','-'), (1269,'CAA','-'), (1270,'SJMC','-'), (1271,'SJMC','-'), (1272,'CL','-'), (1273,'CL','-'), (1274,'CE','-'), (1275,'CAA','-'), (1276,'CE','-'), (1277,'CEC','-'), (1278,'CEC','-'), (1279,'CNHS','-'), (1280,'HC','-'), (1281,'SJMC','-'), (1282,'HC','-'), (1283,'SJMC','-'), (1284,'CAA','-'), (1285,'CNHS','-'), (1286,'CAS','-'), (1287,'SJMC','-'), (1288,'CL','-'), (1289,'CL','-'), (1290,'CL','-'), (1291,'CNHS','-'), (1292,'CEC','-'), (1293,'CNHS','-'), (1294,'CEC','-'), (1295,'SJMC','-'), (1296,'CAA','-'), (1297,'SJMC','-'), (1298,'CAS','-'), (1299,'CNHS','-'), (1300,'CEC','-'), (1301,'HC','-'), (1302,'CE','-'), (1303,'CE','-'), (1304,'CL','-'), (1305,'SJMC','-'), (1306,'HC','-'), (1307,'HC','-'), (1308,'CNHS','-'), (1309,'SJMC','-'), (1310,'CAS','-'), (1311,'CAA','-'), (1312,'CNHS','-'), (1313,'CE','-'), (1314,'CL','-'), (1315,'SJMC','-'), (1316,'CBA','-'), (1317,'CBA','-'), (1318,'CEC','-'), (1319,'HC','-'), (1320,'HC','-'), (1321,'HC','-'), (1322,'CAS','-'), (1323,'CE','-'), (1324,'CE','-'), (1325,'CAA','-'), (1326,'CAS','-'), (1327,'SJMC','-'), (1328,'CNHS','-'), (1329,'CAA','-'), (1330,'HC','-'), (1331,'CAA','-'), (1332,'CL','-'), (1333,'CNHS','-'), (1334,'SJMC','-'), (1335,'CAA','-'), (1336,'CBA','-'), (1337,'CNHS','-'), (1338,'CEC','-'), (1339,'CEC','-'), (1340,'SJMC','-'), (1341,'CE','-'), (1342,'CEC','-'), (1343,'CL','-'), (1344,'CL','-'), (1345,'CBA','-'), (1346,'SJMC','-'), (1347,'CEC','-'), (1348,'CL','-'), (1349,'HC','-'), (1350,'CE','-'), (1351,'SJMC','-'), (1352,'SJMC','-'), (1353,'CE','-'), (1354,'CL','-'), (1355,'SJMC','-'), (1356,'SJMC','-'), (1357,'CAA','-'), (1358,'HC','-'), (1359,'CAS','-'), (1360,'CNHS','-'), (1361,'CAS','-'), (1362,'CNHS','-'), (1363,'CNHS','-'), (1364,'CE','-'), (1365,'CBA','-'), (1366,'CL','-'), (1367,'SJMC','-'), (1368,'SJMC','-'), (1369,'SJMC','-'), (1370,'CNHS','-'), (1371,'CEC','-'), (1372,'CEC','-'), (1373,'CAA','-'), (1374,'CEC','-'), (1375,'HC','-'), (1376,'CAA','-'), (1377,'CBA','-'), (1378,'CBA','-'), (1379,'HC','-'), (1380,'CE','-'), (1381,'CE','-'), (1382,'CAA','-'), (1383,'CBA','-'), (1384,'CAS','-'), (1385,'CL','-'), (1386,'CL','-'), (1387,'CAA','-'), (1388,'CAA','-'), (1389,'CAA','-'), (1390,'CL','-'), (1391,'HC','-'), (1392,'CNHS','-'), (1393,'CAA','-'), (1394,'CBA','-'), (1395,'CAA','-'), (1396,'CL','-'), (1397,'CBA','-'), (1398,'CL','-'), (1399,'CAA','-'), (1400,'CEC','-'), (1401,'CAA','-'), (1402,'CEC','-'), (1403,'CL','-'), (1404,'HC','-'), (1405,'CAS','-'), (1406,'HC','-'), (1407,'CL','-'), (1408,'CBA','-'), (1409,'CNHS','-'), (1410,'CAS','-'), (1411,'CAS','-'), (1412,'HC','-'), (1413,'SJMC','-'), (1414,'CNHS','-'), (1415,'HC','-'), (1416,'SJMC','-'), (1417,'CNHS','-'), (1418,'CE','-'), (1419,'SJMC','-'), (1420,'CL','-'), (1421,'CAS','-'), (1422,'CAS','-'), (1423,'SJMC','-'), (1424,'CBA','-'), (1425,'CBA','-'), (1426,'CE','-'), (1427,'CNHS','-'), (1428,'CAS','-'), (1429,'CL','-'), (1430,'HC','-'), (1431,'CNHS','-'), (1432,'CE','-'), (1433,'CAA','-'), (1434,'SJMC','-'), (1435,'CL','-'), (1436,'HC','-'), (1437,'CL','-'), (1438,'CNHS','-'), (1439,'HC','-'), (1440,'CNHS','-'), (1441,'CL','-'), (1442,'CEC','-'), (1443,'CL','-'), (1444,'HC','-'), (1445,'CNHS','-'), (1446,'CAS','-'), (1447,'CNHS','-'), (1448,'CAS','-'), (1449,'CE','-'), (1450,'CNHS','-'), (1451,'CE','-'), (1452,'CAS','-'), (1453,'HC','-'), (1454,'CBA','-'), (1455,'CE','-'), (1456,'CAS','-'), (1457,'SJMC','-'), (1458,'CBA','-'), (1459,'CAS','-'), (1460,'CNHS','-'), (1461,'CEC','-'), (1462,'SJMC','-'), (1463,'HC','-'), (1464,'HC','-'), (1465,'HC','-'), (1466,'SJMC','-'), (1467,'CAS','-'), (1468,'SJMC','-'), (1469,'CNHS','-'), (1470,'CE','-'), (1471,'HC','-'), (1472,'CAS','-'), (1473,'CNHS','-'), (1474,'CAS','-'), (1475,'CAS','-'), (1476,'HC','-'), (1477,'SJMC','-'), (1478,'CL','-'), (1479,'CAS','-'), (1480,'SJMC','-'), (1481,'CE','-'), (1482,'CAS','-'), (1483,'SJMC','-'), (1484,'SJMC','-'), (1485,'HC','-'), (1486,'HC','-'), (1487,'CAA','-'), (1488,'CAS','-'), (1489,'CNHS','-'), (1490,'CE','-'), (1491,'CBA','-'), (1492,'CBA','-'), (1493,'CBA','-'), (1494,'CE','-'), (1495,'CAS','-'), (1496,'HC','-'), (1497,'CL','-'), (1498,'CL','-'), (1499,'CE','-'), (1500,'CAS','-'), (1501,'CL','-'), (1502,'CE','-'), (1503,'CNHS','-'), (1504,'CE','-'), (1505,'CL','-'), (1506,'CBA','-'), (1507,'SJMC','-'), (1508,'CNHS','-'), (1509,'CE','-'), (1510,'CE','-'), (1511,'CE','-'), (1512,'CE','-'), (1513,'CE','-'), (1514,'CAA','-'), (1515,'CE','-'), (1516,'HC','-'), (1517,'CBA','-'), (1518,'CE','-'), (1519,'CAA','-'), (1520,'CEC','-'), (1521,'CBA','-'), (1522,'SJMC','-'), (1523,'CAS','-'), (1524,'CL','-'), (1525,'CAS','-'), (1526,'CEC','-'), (1527,'SJMC','-'), (1528,'CL','-'), (1529,'CEC','-'), (1530,'HC','-'), (1531,'CBA','-'), (1532,'CEC','-'), (1533,'CNHS','-'), (1534,'CBA','-'), (1535,'CBA','-'), (1536,'CBA','-'), (1537,'SJMC','-'), (1538,'CAA','-'), (1539,'CAS','-'), (1540,'CBA','-'), (1541,'CE','-'), (1542,'CL','-'), (1543,'SJMC','-'), (1544,'CAA','-'), (1545,'CAA','-'), (1546,'CAS','-'), (1547,'CEC','-'), (1548,'CAS','-'), (1549,'SJMC','-'), (1550,'CL','-'), (1551,'CEC','-'), (1552,'CAA','-'), (1553,'CEC','-'), (1554,'CL','-'), (1555,'HC','-'), (1556,'CE','-'), (1557,'CAA','-'), (1558,'CNHS','-'), (1559,'CAS','-'), (1560,'CEC','-'), (1561,'CNHS','-'), (1562,'CEC','-'), (1563,'CBA','-'), (1564,'SJMC','-'), (1565,'CAA','-'), (1566,'CL','-'), (1567,'SJMC','-'), (1568,'CEC','-'), (1569,'CEC','-'), (1570,'CAS','-'), (1571,'SJMC','-'), (1572,'CEC','-'), (1573,'CE','-'), (1574,'CAA','-'), (1575,'SJMC','-'), (1576,'CAS','-'), (1577,'CBA','-'), (1578,'CAA','-'), (1579,'CAA','-'), (1580,'CL','-'), (1581,'CEC','-'), (1582,'CBA','-'), (1583,'CAS','-'), (1584,'CEC','-'), (1585,'CAS','-'), (1586,'CBA','-'), (1587,'CBA','-'), (1588,'CNHS','-'), (1589,'CL','-'), (1590,'CBA','-'), (1591,'HC','-'), (1592,'CBA','-'), (1593,'CBA','-'), (1594,'CBA','-'), (1595,'CL','-'), (1596,'CEC','-'), (1597,'CAA','-'), (1598,'CAA','-'), (1599,'CBA','-'), (1600,'CE','-'), (1601,'CBA','-'), (1602,'CL','-'), (1603,'SJMC','-'), (1604,'CNHS','-'), (1605,'HC','-'), (1606,'CNHS','-'), (1607,'CL','-'), (1608,'HC','-'), (1609,'CNHS','-'), (1610,'CE','-'), (1611,'HC','-'), (1612,'CAS','-'), (1613,'CBA','-'), (1614,'CBA','-'), (1615,'CAA','-'), (1616,'CE','-'), (1617,'CAS','-'), (1618,'CNHS','-'), (1619,'CL','-'), (1620,'CAA','-'), (1621,'CNHS','-'), (1622,'CAS','-'), (1623,'CAA','-'), (1624,'CL','-'), (1625,'CNHS','-'), (1626,'HC','-'), (1627,'CBA','-'), (1628,'CBA','-'), (1629,'CE','-'), (1630,'CE','-'), (1631,'SJMC','-'), (1632,'CL','-'), (1633,'CBA','-'), (1634,'CBA','-'), (1635,'HC','-'), (1636,'SJMC','-'), (1637,'SJMC','-'), (1638,'CAA','-'), (1639,'CAA','-'), (1640,'CAA','-'), (1641,'CL','-'), (1642,'SJMC','-'), (1643,'CAA','-'), (1644,'SJMC','-'), (1645,'CBA','-'), (1646,'CAS','-'), (1647,'CNHS','-'), (1648,'CNHS','-'), (1649,'SJMC','-'), (1650,'CNHS','-'), (1651,'CNHS','-'), (1652,'CBA','-'), (1653,'CL','-'), (1654,'CL','-'), (1655,'CBA','-'), (1656,'CBA','-'), (1657,'SJMC','-'), (1658,'CL','-'), (1659,'CAS','-'), (1660,'CNHS','-'), (1661,'CAS','-'), (1662,'CAA','-'), (1663,'HC','-'), (1664,'CAA','-'), (1665,'CNHS','-'), (1666,'SJMC','-'), (1667,'CBA','-'), (1668,'CBA','-'), (1669,'CEC','-'), (1670,'CL','-'), (1671,'CBA','-'), (1672,'HC','-'), (1673,'CNHS','-'), (1674,'CAA','-'), (1675,'HC','-'), (1676,'SJMC','-'), (1677,'CL','-'), (1678,'CAS','-'), (1679,'CBA','-'), (1680,'CEC','-'), (1681,'CAA','-'), (1682,'CE','-'), (1683,'CAS','-'), (1684,'CEC','-'), (1685,'CNHS','-'), (1686,'CE','-'), (1687,'CEC','-'), (1688,'CAA','-'), (1689,'SJMC','-'), (1690,'CAS','-'), (1691,'CE','-'), (1692,'CL','-'), (1693,'CNHS','-'), (1694,'CAS','-'), (1695,'CEC','-'), (1696,'CL','-'), (1697,'CAA','-'), (1698,'CEC','-'), (1699,'CE','-'), (1700,'CEC','-'), (1701,'CAS','-'), (1702,'CE','-'), (1703,'SJMC','-'), (1704,'CL','-'), (1705,'CE','-'), (1706,'SJMC','-'), (1707,'CAA','-'), (1708,'CAS','-'), (1709,'SJMC','-'), (1710,'CAA','-'), (1711,'CE','-'), (1712,'CBA','-'), (1713,'CAA','-'), (1714,'CAS','-'), (1715,'CE','-'), (1716,'CBA','-'), (1717,'CL','-'), (1718,'CAS','-'), (1719,'CBA','-'), (1720,'CAS','-'), (1721,'HC','-'), (1722,'CNHS','-'), (1723,'CE','-'), (1724,'CE','-'), (1725,'CBA','-'), (1726,'CAS','-'), (1727,'CAS','-'), (1728,'CE','-'), (1729,'CAS','-'), (1730,'CBA','-'), (1731,'CE','-'), (1732,'SJMC','-'), (1733,'HC','-'), (1734,'HC','-'), (1735,'CAA','-'), (1736,'HC','-'), (1737,'SJMC','-'), (1738,'CEC','-'), (1739,'CE','-'), (1740,'CAA','-'), (1741,'CL','-'), (1742,'CL','-'), (1743,'CE','-'), (1744,'CL','-'), (1745,'HC','-'), (1746,'CL','-'), (1747,'HC','-'), (1748,'CEC','-'), (1749,'SJMC','-'), (1750,'HC','-'), (1751,'HC','-'), (1752,'CL','-'), (1753,'SJMC','-'), (1754,'CE','-'), (1755,'CL','-'), (1756,'CEC','-'), (1757,'CE','-'), (1758,'CE','-'), (1759,'CL','-'), (1760,'CAS','-'), (1761,'CBA','-'), (1762,'CBA','-'), (1763,'CNHS','-'), (1764,'CNHS','-'), (1765,'HC','-'), (1766,'CNHS','-'), (1767,'CE','-'), (1768,'CNHS','-'), (1769,'CAA','-'), (1770,'CEC','-'), (1771,'CL','-'), (1772,'CAS','-'), (1773,'CEC','-'), (1774,'CE','-'), (1775,'CNHS','-'), (1776,'CL','-'), (1777,'SJMC','-'), (1778,'HC','-'), (1779,'CAA','-'), (1780,'CE','-'), (1781,'CAS','-'), (1782,'CEC','-'), (1783,'SJMC','-'), (1784,'HC','-'), (1785,'CEC','-'), (1786,'CAA','-'), (1787,'HC','-'), (1788,'CAS','-'), (1789,'CE','-'), (1790,'SJMC','-'), (1791,'CEC','-'), (1792,'CEC','-'), (1793,'CE','-'), (1794,'CAS','-'), (1795,'CAS','-'), (1796,'CBA','-'), (1797,'CEC','-'), (1798,'HC','-'), (1799,'CE','-'), (1800,'SJMC','-'), (1801,'CBA','-'), (1802,'HC','-'), (1803,'CBA','-'), (1804,'CBA','-'), (1805,'CE','-'), (1806,'CNHS','-'), (1807,'CEC','-'), (1808,'HC','-'), (1809,'CAS','-'), (1810,'CAA','-'), (1811,'HC','-'), (1812,'CAA','-'), (1813,'CAS','-'), (1814,'CNHS','-'), (1815,'CEC','-'), (1816,'CEC','-'), (1817,'SJMC','-'), (1818,'CE','-'), (1819,'CEC','-'), (1820,'CL','-'), (1821,'CAA','-'), (1822,'CEC','-'), (1823,'CEC','-'), (1824,'SJMC','-'), (1825,'HC','-'), (1826,'CAA','-'), (1827,'HC','-'), (1828,'CAS','-'), (1829,'CE','-'), (1830,'CEC','-'), (1831,'SJMC','-'), (1832,'CL','-'), (1833,'CNHS','-'), (1834,'CAA','-'), (1835,'CEC','-'), (1836,'SJMC','-'), (1837,'CAA','-'), (1838,'HC','-'), (1839,'CAA','-'), (1840,'CE','-'), (1841,'CL','-'), (1842,'CAA','-'), (1843,'CNHS','-'), (1844,'HC','-'), (1845,'SJMC','-'), (1846,'HC','-'), (1847,'CE','-'), (1848,'HC','-'), (1849,'CEC','-'), (1850,'CAA','-'), (1851,'HC','-'), (1852,'CEC','-'), (1853,'HC','-'), (1854,'HC','-'), (1855,'CAS','-'), (1856,'CL','-'), (1857,'CAS','-'), (1858,'CNHS','-'), (1859,'CAS','-'), (1860,'CAS','-'), (1861,'CL','-'), (1862,'CBA','-'), (1863,'CAS','-'), (1864,'HC','-'), (1865,'CBA','-'), (1866,'CBA','-'), (1867,'CNHS','-'), (1868,'CE','-'), (1869,'CAA','-'), (1870,'CAS','-'), (1871,'CE','-'), (1872,'SJMC','-'), (1873,'HC','-'), (1874,'CBA','-'), (1875,'CE','-'), (1876,'SJMC','-'), (1877,'SJMC','-'), (1878,'CE','-'), (1879,'CBA','-'), (1880,'HC','-'), (1881,'CAS','-'), (1882,'SJMC','-'), (1883,'CAS','-'), (1884,'CAS','-'), (1885,'CBA','-'), (1886,'HC','-'), (1887,'CNHS','-'), (1888,'CNHS','-'), (1889,'CE','-'), (1890,'CEC','-'), (1891,'CEC','-'), (1892,'HC','-'), (1893,'HC','-'), (1894,'CBA','-'), (1895,'CE','-'), (1896,'CAA','-'), (1897,'CBA','-'), (1898,'CNHS','-'), (1899,'CBA','-'), (1900,'CE','-'), (1901,'CAS','-'), (1902,'SJMC','-'), (1903,'CAA','-'), (1904,'CBA','-'), (1905,'CNHS','-'), (1906,'SJMC','-'), (1907,'CAS','-'), (1908,'CL','-'), (1909,'CNHS','-'), (1910,'SJMC','-'), (1911,'SJMC','-'), (1912,'CE','-'), (1913,'SJMC','-'), (1914,'CE','-'), (1915,'CAS','-'), (1916,'CBA','-'), (1917,'CL','-'), (1918,'SJMC','-'), (1919,'SJMC','-'), (1920,'HC','-'), (1921,'SJMC','-'), (1922,'CE','-'), (1923,'CBA','-'), (1924,'SJMC','-'), (1925,'CE','-'), (1926,'CAA','-'), (1927,'CAA','-'), (1928,'CAS','-'), (1929,'CAS','-'), (1930,'SJMC','-'), (1931,'CNHS','-'), (1932,'CBA','-'), (1933,'CE','-'), (1934,'HC','-'), (1935,'CEC','-'), (1936,'CBA','-'), (1937,'SJMC','-'), (1938,'CBA','-'), (1939,'SJMC','-'), (1940,'CE','-'), (1941,'CL','-'), (1942,'CBA','-'), (1943,'SJMC','-'), (1944,'CEC','-'), (1945,'CL','-'), (1946,'HC','-'), (1947,'CNHS','-'), (1948,'CL','-'), (1949,'SJMC','-'), (1950,'CNHS','-'), (1951,'CAA','-'), (1952,'CBA','-'), (1953,'CL','-'), (1954,'CL','-'), (1955,'CL','-'), (1956,'CAS','-'), (1957,'CE','-'), (1958,'HC','-'), (1959,'CEC','-'), (1960,'CNHS','-'), (1961,'CNHS','-'), (1962,'CBA','-'), (1963,'CEC','-'), (1964,'CL','-'), (1965,'HC','-'), (1966,'CAA','-'), (1967,'CAA','-'), (1968,'CAS','-'), (1969,'CE','-'), (1970,'CEC','-'), (1971,'CL','-'), (1972,'CAA','-'), (1973,'HC','-'), (1974,'CBA','-'), (1975,'SJMC','-'), (1976,'SJMC','-'), (1977,'CAS','-'), (1978,'CL','-'), (1979,'CAS','-'), (1980,'CAA','-'), (1981,'CBA','-'), (1982,'CBA','-'), (1983,'CE','-'), (1984,'CBA','-'), (1985,'CBA','-'), (1986,'CL','-'), (1987,'SJMC','-'), (1988,'CAA','-'), (1989,'CBA','-'), (1990,'HC','-'), (1991,'CNHS','-'), (1992,'CNHS','-'), (1993,'HC','-'), (1994,'CL','-'), (1995,'CNHS','-'), (1996,'CAA','-'), (1997,'CE','-'), (1998,'CBA','-'), (1999,'CE','-'), (2000,'CEC','-');

Project Description: Suppose we are to create hypothetical grades information for different schools in a university for analysis purposes. Each school has its own distribution of grades based on a probability set. Please write a function using procedural language PL/pgSQL to randomly assign a grade to each record (for a student) in the table "simulated records" based on the grade probability distribution for each school. Your function will be based on the follow three tables. Please do the following steps to create those tables by using the queries provided in the "Package.zip" file 1. Create a table called "school_probs" by executing query 1_ create_school _probs.sql 2. Insert values into table "school _probs" by executing query 2_insert school_probs.sql 3. Create a table called "grade values" by executing query 3_create_grade_values.sql 4. Insert values into table "grade values" by executing query 4 insert grade_values.sql 5. Create a table called "simulated records" by executing query 5_create_simulated records.sql 6. Insert values into table "simulated_records" by executing query 6_insert_simulated records.sql TABEL 1: school probs TABEL 3: simulated records record id school [PK] bigint texlt grade text probs numericL] 0.05,0.08,0.18,0.3,0.11,0.28 40.06,0.1,0.295,0.36,0.12,0.065 40.05,0.11,0.35,0.32,0.12,0.051 40.04,0.05,0.08,0.3,0.42,0.11 0.05,0.11,0.35,0.32,0.12,0.05) (0.12,0.1,0.23,0.4,0.06,0.09 0.07,0.09,0.24,0.4,0.12,0.08) 0.08,0.1,0.295,0.34,0.12,0.065 0.09,0.11,0.31,0.32,0.12,0.05h school code school [PK] bigint tet CEC CEC CEC CAS ??? CEC ?? CL CAS CAA CAA CAA CL CBA CAA ?? CL SJMC TABEL 2: grade values grade text score [PK] integer text 13 95 100 90-94 80-89 70 -79 60 69 15 16 CBA Project Description: Suppose we are to create hypothetical grades information for different schools in a university for analysis purposes. Each school has its own distribution of grades based on a probability set. Please write a function using procedural language PL/pgSQL to randomly assign a grade to each record (for a student) in the table "simulated records" based on the grade probability distribution for each school. Your function will be based on the follow three tables. Please do the following steps to create those tables by using the queries provided in the "Package.zip" file 1. Create a table called "school_probs" by executing query 1_ create_school _probs.sql 2. Insert values into table "school _probs" by executing query 2_insert school_probs.sql 3. Create a table called "grade values" by executing query 3_create_grade_values.sql 4. Insert values into table "grade values" by executing query 4 insert grade_values.sql 5. Create a table called "simulated records" by executing query 5_create_simulated records.sql 6. Insert values into table "simulated_records" by executing query 6_insert_simulated records.sql TABEL 1: school probs TABEL 3: simulated records record id school [PK] bigint texlt grade text probs numericL] 0.05,0.08,0.18,0.3,0.11,0.28 40.06,0.1,0.295,0.36,0.12,0.065 40.05,0.11,0.35,0.32,0.12,0.051 40.04,0.05,0.08,0.3,0.42,0.11 0.05,0.11,0.35,0.32,0.12,0.05) (0.12,0.1,0.23,0.4,0.06,0.09 0.07,0.09,0.24,0.4,0.12,0.08) 0.08,0.1,0.295,0.34,0.12,0.065 0.09,0.11,0.31,0.32,0.12,0.05h school code school [PK] bigint tet CEC CEC CEC CAS ??? CEC ?? CL CAS CAA CAA CAA CL CBA CAA ?? CL SJMC TABEL 2: grade values grade text score [PK] integer text 13 95 100 90-94 80-89 70 -79 60 69 15 16 CBA