INSERT INTO result_subject VALUES
("728","27","3","0","JSS 3","","HAUSA","16","5","10","0","10","","","","","","","25","15","40","40","0","","","7th","E8","POOR","YAKUBU HAJARA","FAIR, TRY HARDER NEXT TIME","0","100","5","5","5","5","5","5","5","5","5","5","submit","2021/2022","2nd Term"),
("729","29","3","0","JSS 3","","HAUSA","16","10","10","0","10","","","","","","","30","35","65","65","0","","","2nd","B3","GOOD","YAKUBU HAJARA","SATISFACTORY. YOU CAN DO BETTER.","0","100","5","5","5","5","5","5","5","5","5","5","submit","2021/2022","2nd Term"),
("730","30","3","0","JSS 3","","HAUSA","16","5","10","0","10","","","","","","","25","10","35","35","0","","","8th","F9","FAIL","YAKUBU HAJARA","FAIR, YOU CAN DO BETTER","0","100","5","5","5","5","5","5","5","5","5","5","submit","2021/2022","2nd Term"),
("731","33","3","0","JSS 3","","HAUSA","16","3","10","0","10","","","","","","","23","26","49","49","0","","","5th","D7","PASS","YAKUBU HAJARA","FAIR, TRY HARDER NEXT TIME","0","100","5","5","5","5","5","5","5","5","5","5","submit","2021/2022","2nd Term"),
("732","31","3","0","JSS 3","","HAUSA","16","2","9","0","10","","","","","","","21","20","41","41","0","","","6th","E8","POOR","YAKUBU HAJARA","FAIR, TRY HARDER NEXT TIME","0","100","5","5","5","5","5","5","5","5","5","5","submit","2021/2022","2nd Term"),
("733","28","3","0","JSS 3","","HAUSA","16","7","10","0","10","","","","","","","27","25","52","52","0","","","4th","C6","CREDIT","YAKUBU HAJARA","GOOD WORK. WORK HARDER","0","100","5","5","5","5","5","5","5","5","5","5","submit","2021/2022","2nd Term"),
("734","32","3","0","JSS 3","","HAUSA","16","10","10","8","10","","","","","","","38","44","82","82","0","","","1st","A1","EXCELLENT","YAKUBU HAJARA","EXCELLENT PERFORMANCE, KEEP IT UP","0","100","5","5","5","5","5","5","5","5","5","5","submit","2021/2022","2nd Term"),
("735","29","3","0","JSS 3","","ISLAMIC RELIGIOUS STUDIES","7","5","6","4","10","","","","","","","25","39","64","64","0","","","1st","C4","CREDIT","YAKUBU HAJARA","SATISFACTORY. YOU CAN DO BETTER.","0","100","5","5","5","5","5","5","5","5","5","5","submit","2021/2022","2nd Term"),
("736","2","1","0","JSS 1","","BASIC SCIENCE","5","10","7","9","6","","","","","","","32","47","79","79","0","","","4th","B2","VERY GOOD","CHUKWU NNEKA","VERY GOOD, WELL DONE","0","100","5","5","5","5","5","5","5","5","5","5","submit","2021/2022","2nd Term"),
("737","35","1","0","JSS 1","","BASIC SCIENCE","5","10","6","5","8","","","","","","","29","35","64","64","0","","","9th","C4","CREDIT","CHUKWU NNEKA","SATISFACTORY. YOU CAN DO BETTER.","0","100","5","5","5","5","5","5","5","5","5","5","submit","2021/2022","2nd Term"),
("738","1","1","0","JSS 1","","BASIC SCIENCE","5","10","7","6","8","","","","","","","31","37","68","68","0","","","7th","B3","GOOD","CHUKWU NNEKA","SATISFACTORY. YOU CAN DO BETTER.","0","100","5","5","5","5","5","5","5","5","5","5","submit","2021/2022","2nd Term"),
("739","3","1","0","JSS 1","","BASIC SCIENCE","5","3","3","4","6","","","","","","","16","10","26","26","0","","","13th","F9","FAIL","CHUKWU NNEKA","FAIR, YOU CAN DO BETTER","0","100","5","5","5","5","5","5","5","5","5","5","submit","2021/2022","2nd Term"),
("740","4","1","0","JSS 1","","BASIC SCIENCE","5","10","8","8","9","","","","","","","35","56","91","91","0","","","1st","A1","DISTINCTION","CHUKWU NNEKA","EXCEPTIONAL WORK. WONDERFULLY DONE.","0","100","5","5","5","5","5","5","5","5","5","5","submit","2021/2022","2nd Term"),
("741","6","1","0","JSS 1","","BASIC SCIENCE","5","4","1","1","4","","","","","","","10","6","16","16","0","","","14th","F9","FAIL","CHUKWU NNEKA","FAIR, YOU CAN DO BETTER","0","100","5","5","5","5","5","5","5","5","5","5","submit","2021/2022","2nd Term"),
("742","7","1","0","JSS 1","","BASIC SCIENCE","5","10","3","5","6","","","","","","","24","23","47","47","0","","","11th","D7","PASS","CHUKWU NNEKA","FAIR, TRY HARDER NEXT TIME","0","100","5","5","5","5","5","5","5","5","5","5","submit","2021/2022","2nd Term"),
("743","8","1","0","JSS 1","","BASIC SCIENCE","5","5","4","6","6","","","","","","","21","20","41","41","0","","","12th","E8","POOR","CHUKWU NNEKA","FAIR, TRY HARDER NEXT TIME","0","100","5","5","5","5","5","5","5","5","5","5","submit","2021/2022","2nd Term"),
("744","9","1","0","JSS 1","","BASIC SCIENCE","5","6","5","3","6","","","","","","","20","38","58","58","0","","","10th","C5","CREDIT","CHUKWU NNEKA","GOOD WORK. WORK HARDER","0","100","5","5","5","5","5","5","5","5","5","5","submit","2021/2022","2nd Term"),
("745","10","1","0","JSS 1","","BASIC SCIENCE","5","10","9","7","6","","","","","","","32","38","70","70","0","","","6th","B2","VERY GOOD","CHUKWU NNEKA","VERY GOOD, WELL DONE","0","100","5","5","5","5","5","5","5","5","5","5","submit","2021/2022","2nd Term"),
("746","11","1","0","JSS 1","","BASIC SCIENCE","5","10","9","6","5","","","","","","","30","44","74","74","0","","","5th","B2","VERY GOOD","CHUKWU NNEKA","VERY GOOD, WELL DONE","0","100","5","5","5","5","5","5","5","5","5","5","submit","2021/2022","2nd Term"),
("747","13","1","0","JSS 1","","BASIC SCIENCE","5","5","10","9","7","","","","","","","31","37","68","68","0","","","7th","B3","GOOD","CHUKWU NNEKA","SATISFACTORY. YOU CAN DO BETTER.","0","100","5","5","5","5","5","5","5","5","5","5","submit","2021/2022","2nd Term"),
("748","5","1","0","JSS 1","","BASIC SCIENCE","5","10","9","8","9","","","","","","","36","48","84","84","0","","","2nd","A1","EXCELLENT","CHUKWU NNEKA","EXCELLENT PERFORMANCE, KEEP IT UP","0","100","5","5","5","5","5","5","5","5","5","5","submit","2021/2022","2nd Term"),
("749","14","1","0","JSS 1","","BASIC SCIENCE","5","10","8","9","9","","","","","","","36","46","82","82","0","","","3rd","A1","EXCELLENT","CHUKWU NNEKA","EXCELLENT PERFORMANCE, KEEP IT UP","0","100","5","5","5","5","5","5","5","5","5","5","submit","2021/2022","2nd Term"),
("750","2","1","0","JSS 1","","HOME ECONOMICS","6","10","10","10","6","","","","","","","36","51","87","87","0","","","3rd","A1","EXCELLENT","CHUKWU NNEKA","EXCELLENT PERFORMANCE, KEEP IT UP","0","100","5","5","5","5","5","5","5","5","5","5","submit","2021/2022","2nd Term"),
("751","35","1","0","JSS 1","","HOME ECONOMICS","6","10","9","9","8","","","","","","","36","30","66","66","0","","","7th","B3","GOOD","CHUKWU NNEKA","SATISFACTORY. YOU CAN DO BETTER.","0","100","5","5","5","5","5","5","5","5","5","5","submit","2021/2022","2nd Term"),
("752","1","1","0","JSS 1","","HOME ECONOMICS","6","10","6","7","7","","","","","","","30","35","65","65","0","","","8th","B3","GOOD","CHUKWU NNEKA","SATISFACTORY. YOU CAN DO BETTER.","0","100","5","5","5","5","5","5","5","5","5","5","submit","2021/2022","2nd Term"),
("753","3","1","0","JSS 1","","HOME ECONOMICS","6","3","2","8","6","","","","","","","19","18","37","37","0","","","13th","F9","FAIL","CHUKWU NNEKA","FAIR, YOU CAN DO BETTER","0","100","5","5","5","5","5","5","5","5","5","5","submit","2021/2022","2nd Term"),
("754","4","1","0","JSS 1","","HOME ECONOMICS","6","10","7","8","9","","","","","","","34","53","87","87","0","","","3rd","A1","EXCELLENT","CHUKWU NNEKA","EXCELLENT PERFORMANCE, KEEP IT UP","0","100","5","5","5","5","5","5","5","5","5","5","submit","2021/2022","2nd Term"),
("755","6","1","0","JSS 1","","HOME ECONOMICS","6","0","4","4","4","","","","","","","12","25","37","37","0","","","13th","F9","FAIL","CHUKWU NNEKA","FAIR, YOU CAN DO BETTER","0","100","5","5","5","5","5","5","5","5","5","5","submit","2021/2022","2nd Term"),
("756","7","1","0","JSS 1","","HOME ECONOMICS","6","4","9","8","5","","","","","","","26","30","56","56","0","","","11th","C5","CREDIT","CHUKWU NNEKA","GOOD WORK. WORK HARDER","0","100","5","5","5","5","5","5","5","5","5","5","submit","2021/2022","2nd Term"),
("757","8","1","0","JSS 1","","HOME ECONOMICS","6","2","6","10","6","","","","","","","24","39","63","63","0","","","9th","C4","CREDIT","CHUKWU NNEKA","SATISFACTORY. YOU CAN DO BETTER.","0","100","5","5","5","5","5","5","5","5","5","5","submit","2021/2022","2nd Term"),
("758","9","1","0","JSS 1","","HOME ECONOMICS","6","1","8","7","6","","","","","","","22","31","53","53","0","","","12th","C6","CREDIT","CHUKWU NNEKA","GOOD WORK. WORK HARDER","0","100","5","5","5","5","5","5","5","5","5","5","submit","2021/2022","2nd Term"),
("759","10","1","0","JSS 1","","HOME ECONOMICS","6","3","10","7","6","","","","","","","26","47","73","73","0","","","6th","B2","VERY GOOD","CHUKWU NNEKA","VERY GOOD, WELL DONE","0","100","5","5","5","5","5","5","5","5","5","5","submit","2021/2022","2nd Term"),
("760","11","1","0","JSS 1","","HOME ECONOMICS","6","10","10","10","5","","","","","","","35","55","90","90","0","","","2nd","A1","DISTINCTION","CHUKWU NNEKA","EXCEPTIONAL WORK. WONDERFULLY DONE.","0","100","5","5","5","5","5","5","5","5","5","5","submit","2021/2022","2nd Term"),
("761","13","1","0","JSS 1","","HOME ECONOMICS","6","3","8","4","7","","","","","","","22","35","57","57","0","","","10th","C5","CREDIT","CHUKWU NNEKA","GOOD WORK. WORK HARDER","0","100","5","5","5","5","5","5","5","5","5","5","submit","2021/2022","2nd Term"),
("762","5","1","0","JSS 1","","HOME ECONOMICS","6","10","8","10","9","","","","","","","37","56","93","93","0","","","1st","A1","DISTINCTION","CHUKWU NNEKA","EXCEPTIONAL WORK. WONDERFULLY DONE.","0","100","5","5","5","5","5","5","5","5","5","5","submit","2021/2022","2nd Term"),
("763","14","1","0","JSS 1","","HOME ECONOMICS","6","8","8","8","9","","","","","","","33","49","82","82","0","","","5th","A1","EXCELLENT","CHUKWU NNEKA","EXCELLENT PERFORMANCE, KEEP IT UP","0","100","5","5","5","5","5","5","5","5","5","5","submit","2021/2022","2nd Term"),
("764","15","2","0","JSS 2","","AGRICULTURAL SCIENCE","8","9","9","10","7","","","","","","","35","51","86","86","0","","","3rd","A1","EXCELLENT","CHUKWU NNEKA","EXCELLENT PERFORMANCE, KEEP IT UP","0","100","5","5","5","5","5","5","5","5","5","5","submit","2021/2022","2nd Term"),
("765","16","2","0","JSS 2","","AGRICULTURAL SCIENCE","8","9","10","10","7","","","","","","","36","54","90","90","0","","","2nd","A1","DISTINCTION","CHUKWU NNEKA","EXCEPTIONAL WORK. WONDERFULLY DONE.","0","100","5","5","5","5","5","5","5","5","5","5","submit","2021/2022","2nd Term"),
("766","17","2","0","JSS 2","","AGRICULTURAL SCIENCE","8","7","8","9","8","","","","","","","32","49","81","81","0","","","4th","A1","EXCELLENT","CHUKWU NNEKA","EXCELLENT PERFORMANCE, KEEP IT UP","0","100","5","5","5","5","5","5","5","5","5","5","submit","2021/2022","2nd Term"),
("767","18","2","0","JSS 2","","AGRICULTURAL SCIENCE","8","10","10","10","8","","","","","","","38","58","96","96","0","","","1st","A1","DISTINCTION","CHUKWU NNEKA","EXCEPTIONAL WORK. WONDERFULLY DONE.","0","100","5","5","5","5","5","5","5","5","5","5","submit","2021/2022","2nd Term"),
("768","19","2","0","JSS 2","","AGRICULTURAL SCIENCE","8","8","10","9","7","","","","","","","34","41","75","75","0","","","8th","B2","VERY GOOD","CHUKWU NNEKA","VERY GOOD, WELL DONE","0","100","5","5","5","5","5","5","5","5","5","5","submit","2021/2022","2nd Term"),
("769","20","2","0","JSS 2","","AGRICULTURAL SCIENCE","8","7","7","10","8","","","","","","","32","42","74","74","0","","","9th","B2","VERY GOOD","CHUKWU NNEKA","VERY GOOD, WELL DONE","0","100","5","5","5","5","5","5","5","5","5","5","submit","2021/2022","2nd Term"),
("770","21","2","0","JSS 2","","AGRICULTURAL SCIENCE","8","6","8","9","7","","","","","","","30","49","79","79","0","","","6th","B2","VERY GOOD","CHUKWU NNEKA","VERY GOOD, WELL DONE","0","100","5","5","5","5","5","5","5","5","5","5","submit","2021/2022","2nd Term"),
("771","22","2","0","JSS 2","","AGRICULTURAL SCIENCE","8","4","10","9","5","","","","","","","28","36","64","64","0","","","10th","C4","CREDIT","CHUKWU NNEKA","SATISFACTORY. YOU CAN DO BETTER.","0","100","5","5","5","5","5","5","5","5","5","5","submit","2021/2022","2nd Term"),
("772","23","2","0","JSS 2","","AGRICULTURAL SCIENCE","8","6","8","10","7","","","","","","","31","45","76","76","0","","","7th","B2","VERY GOOD","CHUKWU NNEKA","VERY GOOD, WELL DONE","0","100","5","5","5","5","5","5","5","5","5","5","submit","2021/2022","2nd Term"),
("773","34","2","0","JSS 2","","AGRICULTURAL SCIENCE","8","6","10","10","7","","","","","","","33","47","80","80","0","","","5th","A1","EXCELLENT","CHUKWU NNEKA","EXCELLENT PERFORMANCE, KEEP IT UP","0","100","5","5","5","5","5","5","5","5","5","5","submit","2021/2022","2nd Term"),
("774","15","2","0","JSS 2","","BASIC SCIENCE","5","3","5","10","8","","","","","","","26","34","60","60","0","","","9th","C4","CREDIT","CHUKWU NNEKA","SATISFACTORY. YOU CAN DO BETTER.","0","100","5","5","5","5","5","5","5","5","5","5","submit","2021/2022","2nd Term"),
("775","16","2","0","JSS 2","","BASIC SCIENCE","5","8","8","10","8","","","","","","","34","40","74","74","0","","","4th","B2","VERY GOOD","CHUKWU NNEKA","VERY GOOD, WELL DONE","0","100","5","5","5","5","5","5","5","5","5","5","submit","2021/2022","2nd Term"),
("776","17","2","0","JSS 2","","BASIC SCIENCE","5","8","7","10","8","","","","","","","33","37","70","70","0","","","6th","B2","VERY GOOD","CHUKWU NNEKA","VERY GOOD, WELL DONE","0","100","5","5","5","5","5","5","5","5","5","5","submit","2021/2022","2nd Term"),
("777","18","2","0","JSS 2","","BASIC SCIENCE","5","10","8","10","8","","","","","","","36","57","93","93","0","","","1st","A1","DISTINCTION","CHUKWU NNEKA","EXCEPTIONAL WORK. WONDERFULLY DONE.","0","100","5","5","5","5","5","5","5","5","5","5","submit","2021/2022","2nd Term"),
("778","19","2","0","JSS 2","","BASIC SCIENCE","5","8","5","9","8","","","","","","","30","38","68","68","0","","","7th","B3","GOOD","CHUKWU NNEKA","SATISFACTORY. YOU CAN DO BETTER.","0","100","5","5","5","5","5","5","5","5","5","5","submit","2021/2022","2nd Term"),
("779","20","2","0","JSS 2","","BASIC SCIENCE","5","9","9","10","8","","","","","","","36","53","89","89","0","","","2nd","A1","EXCELLENT","CHUKWU NNEKA","EXCELLENT PERFORMANCE, KEEP IT UP","0","100","5","5","5","5","5","5","5","5","5","5","submit","2021/2022","2nd Term"),
("780","21","2","0","JSS 2","","BASIC SCIENCE","5","7","4","8","6","","","","","","","25","40","65","65","0","","","8th","B3","GOOD","CHUKWU NNEKA","SATISFACTORY. YOU CAN DO BETTER.","0","100","5","5","5","5","5","5","5","5","5","5","submit","2021/2022","2nd Term"),
("781","22","2","0","JSS 2","","BASIC SCIENCE","5","3","4","9","5","","","","","","","21","16","37","37","0","","","10th","F9","FAIL","CHUKWU NNEKA","FAIR, YOU CAN DO BETTER","0","100","5","5","5","5","5","5","5","5","5","5","submit","2021/2022","2nd Term"),
("782","23","2","0","JSS 2","","BASIC SCIENCE","5","8","9","10","8","","","","","","","35","37","72","72","0","","","5th","B2","VERY GOOD","CHUKWU NNEKA","VERY GOOD, WELL DONE","0","100","5","5","5","5","5","5","5","5","5","5","submit","2021/2022","2nd Term"),
("783","34","2","0","JSS 2","","BASIC SCIENCE","5","6","10","10","8","","","","","","","34","41","75","75","0","","","3rd","B2","VERY GOOD","CHUKWU NNEKA","VERY GOOD, WELL DONE","0","100","5","5","5","5","5","5","5","5","5","5","submit","2021/2022","2nd Term"),
("784","15","2","0","JSS 2","","HOME ECONOMICS","6","9","6","10","8","","","","","","","33","50","83","83","0","","","7th","A1","EXCELLENT","CHUKWU NNEKA","EXCELLENT PERFORMANCE, KEEP IT UP","0","100","5","5","5","5","5","5","5","5","5","5","submit","2021/2022","2nd Term"),
("785","16","2","0","JSS 2","","HOME ECONOMICS","6","10","10","10","8","","","","","","","38","57","95","95","0","","","1st","A1","DISTINCTION","CHUKWU NNEKA","EXCEPTIONAL WORK. WONDERFULLY DONE.","0","100","5","5","5","5","5","5","5","5","5","5","submit","2021/2022","2nd Term"),
("786","17","2","0","JSS 2","","HOME ECONOMICS","6","6","10","9","7","","","","","","","32","59","91","91","0","","","5th","A1","DISTINCTION","CHUKWU NNEKA","EXCEPTIONAL WORK. WONDERFULLY DONE.","0","100","5","5","5","5","5","5","5","5","5","5","submit","2021/2022","2nd Term"),
("787","18","2","0","JSS 2","","HOME ECONOMICS","6","10","10","10","8","","","","","","","38","55","93","93","0","","","2nd","A1","DISTINCTION","CHUKWU NNEKA","EXCEPTIONAL WORK. WONDERFULLY DONE.","0","100","5","5","5","5","5","5","5","5","5","5","submit","2021/2022","2nd Term"),
("788","19","2","0","JSS 2","","HOME ECONOMICS","6","10","4","10","7","","","","","","","31","48","79","79","0","","","8th","B2","VERY GOOD","CHUKWU NNEKA","VERY GOOD, WELL DONE","0","100","5","5","5","5","5","5","5","5","5","5","submit","2021/2022","2nd Term"),
("789","20","2","0","JSS 2","","HOME ECONOMICS","6","10","10","10","8","","","","","","","38","54","92","92","0","","","3rd","A1","DISTINCTION","CHUKWU NNEKA","EXCEPTIONAL WORK. WONDERFULLY DONE.","0","100","5","5","5","5","5","5","5","5","5","5","submit","2021/2022","2nd Term"),
("790","21","2","0","JSS 2","","HOME ECONOMICS","6","6","7","9","7","","","","","","","29","50","79","79","0","","","8th","B2","VERY GOOD","CHUKWU NNEKA","VERY GOOD, WELL DONE","0","100","5","5","5","5","5","5","5","5","5","5","submit","2021/2022","2nd Term"),
("791","22","2","0","JSS 2","","HOME ECONOMICS","6","9","6","8","5","","","","","","","28","46","74","74","0","","","10th","B2","VERY GOOD","CHUKWU NNEKA","VERY GOOD, WELL DONE","0","100","5","5","5","5","5","5","5","5","5","5","submit","2021/2022","2nd Term"),
("792","23","2","0","JSS 2","","HOME ECONOMICS","6","8","10","9","8","","","","","","","35","51","86","86","0","","","6th","A1","EXCELLENT","CHUKWU NNEKA","EXCELLENT PERFORMANCE, KEEP IT UP","0","100","5","5","5","5","5","5","5","5","5","5","submit","2021/2022","2nd Term"),
("793","34","2","0","JSS 2","","HOME ECONOMICS","6","6","9","10","8","","","","","","","33","59","92","92","0","","","3rd","A1","DISTINCTION","CHUKWU NNEKA","EXCEPTIONAL WORK. WONDERFULLY DONE.","0","100","5","5","5","5","5","5","5","5","5","5","submit","2021/2022","2nd Term"),
("794","26","3","0","JSS 3","","AGRICULTURAL SCIENCE","8","10","8","10","8","","","","","","","36","53","89","89","0","","","1st","A1","EXCELLENT","CHUKWU NNEKA","EXCELLENT PERFORMANCE, KEEP IT UP","0","100","5","5","5","5","5","5","5","5","5","5","submit","2021/2022","2nd Term"),
("795","27","3","0","JSS 3","","AGRICULTURAL SCIENCE","8","5","2","8","7","","","","","","","22","27","49","49","0","","","7th","D7","PASS","CHUKWU NNEKA","FAIR, TRY HARDER NEXT TIME","0","100","5","5","5","5","5","5","5","5","5","5","submit","2021/2022","2nd Term"),
("796","29","3","0","JSS 3","","AGRICULTURAL SCIENCE","8","10","4","8","7","","","","","","","29","33","62","62","0","","","5th","C4","CREDIT","CHUKWU NNEKA","SATISFACTORY. YOU CAN DO BETTER.","0","100","5","5","5","5","5","5","5","5","5","5","submit","2021/2022","2nd Term"),
("797","30","3","0","JSS 3","","AGRICULTURAL SCIENCE","8","1","1","1","7","","","","","","","10","7","17","17","0","","","8th","F9","FAIL","CHUKWU NNEKA","FAIR, YOU CAN DO BETTER","0","100","5","5","5","5","5","5","5","5","5","5","submit","2021/2022","2nd Term"),
("798","33","3","0","JSS 3","","AGRICULTURAL SCIENCE","8","8","8","3","3","","","","","","","22","35","57","57","0","","","6th","C5","CREDIT","CHUKWU NNEKA","GOOD WORK. WORK HARDER","0","100","5","5","5","5","5","5","5","5","5","5","submit","2021/2022","2nd Term"),
("799","31","3","0","JSS 3","","AGRICULTURAL SCIENCE","8","5","5","8","6","","","","","","","24","40","64","64","0","","","4th","C4","CREDIT","CHUKWU NNEKA","SATISFACTORY. YOU CAN DO BETTER.","0","100","5","5","5","5","5","5","5","5","5","5","submit","2021/2022","2nd Term"),
("800","28","3","0","JSS 3","","AGRICULTURAL SCIENCE","8","6","8","9","6","","","","","","","29","45","74","74","0","","","3rd","B2","VERY GOOD","CHUKWU NNEKA","VERY GOOD, WELL DONE","0","100","5","5","5","5","5","5","5","5","5","5","submit","2021/2022","2nd Term"),
("801","32","3","0","JSS 3","","AGRICULTURAL SCIENCE","8","9","10","10","8","","","","","","","37","46","83","83","0","","","2nd","A1","EXCELLENT","CHUKWU NNEKA","EXCELLENT PERFORMANCE, KEEP IT UP","0","100","5","5","5","5","5","5","5","5","5","5","submit","2021/2022","2nd Term"),
("802","26","3","0","JSS 3","","BASIC SCIENCE","5","10","7","9","8","","","","","","","34","53","87","87","0","","","1st","A1","EXCELLENT","CHUKWU NNEKA","EXCELLENT PERFORMANCE, KEEP IT UP","0","100","5","5","5","5","5","5","5","5","5","5","submit","2021/2022","2nd Term"),
("803","27","3","0","JSS 3","","BASIC SCIENCE","5","8","3","5","6","","","","","","","22","26","48","48","0","","","6th","D7","PASS","CHUKWU NNEKA","FAIR, TRY HARDER NEXT TIME","0","100","5","5","5","5","5","5","5","5","5","5","submit","2021/2022","2nd Term"),
("804","29","3","0","JSS 3","","BASIC SCIENCE","5","5","2","7","5","","","","","","","19","37","56","56","0","","","4th","C5","CREDIT","CHUKWU NNEKA","GOOD WORK. WORK HARDER","0","100","5","5","5","5","5","5","5","5","5","5","submit","2021/2022","2nd Term"),
("805","30","3","0","JSS 3","","BASIC SCIENCE","5","1","1","1","6","","","","","","","9","4","13","13","0","","","8th","F9","FAIL","CHUKWU NNEKA","FAIR, YOU CAN DO BETTER","0","100","5","5","5","5","5","5","5","5","5","5","submit","2021/2022","2nd Term"),
("806","33","3","0","JSS 3","","BASIC SCIENCE","5","5","2","8","2","","","","","","","17","29","46","46","0","","","7th","D7","PASS","CHUKWU NNEKA","FAIR, TRY HARDER NEXT TIME","0","100","5","5","5","5","5","5","5","5","5","5","submit","2021/2022","2nd Term"),
("807","31","3","0","JSS 3","","BASIC SCIENCE","5","7","3","4","6","","","","","","","20","35","55","55","0","","","5th","C5","CREDIT","CHUKWU NNEKA","GOOD WORK. WORK HARDER","0","100","5","5","5","5","5","5","5","5","5","5","submit","2021/2022","2nd Term"),
("808","28","3","0","JSS 3","","BASIC SCIENCE","5","7","6","6","3","","","","","","","22","36","58","58","0","","","3rd","C5","CREDIT","CHUKWU NNEKA","GOOD WORK. WORK HARDER","0","100","5","5","5","5","5","5","5","5","5","5","submit","2021/2022","2nd Term"),
("809","32","3","0","JSS 3","","BASIC SCIENCE","5","8","7","10","7","","","","","","","32","47","79","79","0","","","2nd","B2","VERY GOOD","CHUKWU NNEKA","VERY GOOD, WELL DONE","0","100","5","5","5","5","5","5","5","5","5","5","submit","2021/2022","2nd Term"),
("810","26","3","0","JSS 3","","HOME ECONOMICS","6","10","10","9","8","","","","","","","37","51","88","88","0","","","1st","A1","EXCELLENT","CHUKWU NNEKA","EXCELLENT PERFORMANCE, KEEP IT UP","0","100","5","5","5","5","5","5","5","5","5","5","submit","2021/2022","2nd Term"),
("811","27","3","0","JSS 3","","HOME ECONOMICS","6","9","1","1","7","","","","","","","18","23","41","41","0","","","7th","E8","POOR","CHUKWU NNEKA","FAIR, TRY HARDER NEXT TIME","0","100","5","5","5","5","5","5","5","5","5","5","submit","2021/2022","2nd Term"),
("812","29","3","0","JSS 3","","HOME ECONOMICS","6","10","4","5","3","","","","","","","22","41","63","63","0","","","4th","C4","CREDIT","CHUKWU NNEKA","SATISFACTORY. YOU CAN DO BETTER.","0","100","5","5","5","5","5","5","5","5","5","5","submit","2021/2022","2nd Term"),
("813","30","3","0","JSS 3","","HOME ECONOMICS","6","1","1","1","6","","","","","","","9","1","10","10","0","","","8th","F9","FAIL","CHUKWU NNEKA","FAIR, YOU CAN DO BETTER","0","100","5","5","5","5","5","5","5","5","5","5","submit","2021/2022","2nd Term"),
("814","33","3","0","JSS 3","","HOME ECONOMICS","6","8","4","5","3","","","","","","","20","38","58","58","0","","","5th","C5","CREDIT","CHUKWU NNEKA","GOOD WORK. WORK HARDER","0","100","5","5","5","5","5","5","5","5","5","5","submit","2021/2022","2nd Term"),
("815","31","3","0","JSS 3","","HOME ECONOMICS","6","9","2","1","5","","","","","","","17","41","58","58","0","","","5th","C5","CREDIT","CHUKWU NNEKA","GOOD WORK. WORK HARDER","0","100","5","5","5","5","5","5","5","5","5","5","submit","2021/2022","2nd Term"),
("816","28","3","0","JSS 3","","HOME ECONOMICS","6","10","8","8","6","","","","","","","32","52","84","84","0","","","2nd","A1","EXCELLENT","CHUKWU NNEKA","EXCELLENT PERFORMANCE, KEEP IT UP","0","100","5","5","5","5","5","5","5","5","5","5","submit","2021/2022","2nd Term"),
("817","32","3","0","JSS 3","","HOME ECONOMICS","6","10","10","9","7","","","","","","","36","48","84","84","0","","","2nd","A1","EXCELLENT","CHUKWU NNEKA","EXCELLENT PERFORMANCE, KEEP IT UP","0","100","5","5","5","5","5","5","5","5","5","5","submit","2021/2022","2nd Term"),
("818","35","1","0","JSS 1","","CHRISTIAN RELIGIOUS STUDIES","13","3","3","3","10","","","","","","","19","38","57","57","0","","","6th","C5","CREDIT","MRS OKPEAJI","GOOD WORK. WORK HARDER","0","100","5","5","5","5","5","5","5","5","5","5","submit","2021/2022","2nd Term"),
("819","1","1","0","JSS 1","","CHRISTIAN RELIGIOUS STUDIES","13","5","5","4","9","","","","","","","23","43","66","66","0","","","3rd","B3","GOOD","MRS OKPEAJI","SATISFACTORY. YOU CAN DO BETTER.","0","100","5","5","5","5","5","5","5","5","5","5","submit","2021/2022","2nd Term"),
("820","3","1","0","JSS 1","","CHRISTIAN RELIGIOUS STUDIES","13","2","2","1","10","","","","","","","15","21","36","36","0","","","9th","F9","FAIL","MRS OKPEAJI","FAIR, YOU CAN DO BETTER","0","100","5","5","5","5","5","5","5","5","5","5","submit","2021/2022","2nd Term"),
("821","4","1","0","JSS 1","","CHRISTIAN RELIGIOUS STUDIES","13","4","4","4","10","","","","","","","22","49","71","71","0","","","1st","B2","VERY GOOD","MRS OKPEAJI","VERY GOOD, WELL DONE","0","100","5","5","5","5","5","5","5","5","5","5","submit","2021/2022","2nd Term"),
("822","7","1","0","JSS 1","","CHRISTIAN RELIGIOUS STUDIES","13","3","2","1","5","","","","","","","11","24","35","35","0","","","11th","F9","FAIL","MRS OKPEAJI","FAIR, YOU CAN DO BETTER","0","100","5","5","5","5","5","5","5","5","5","5","submit","2021/2022","2nd Term"),
("823","8","1","0","JSS 1","","CHRISTIAN RELIGIOUS STUDIES","13","2","2","1","5","","","","","","","10","30","40","40","0","","","8th","E8","POOR","MRS OKPEAJI","FAIR, TRY HARDER NEXT TIME","0","100","5","5","5","5","5","5","5","5","5","5","submit","2021/2022","2nd Term"),
("824","9","1","0","JSS 1","","CHRISTIAN RELIGIOUS STUDIES","13","2","2","1","5","","","","","","","10","26","36","36","0","","","9th","F9","FAIL","MRS OKPEAJI","FAIR, YOU CAN DO BETTER","0","100","5","5","5","5","5","5","5","5","5","5","submit","2021/2022","2nd Term"),
("825","10","1","0","JSS 1","","CHRISTIAN RELIGIOUS STUDIES","13","5","5","5","10","","","","","","","25","41","66","66","0","","","3rd","B3","GOOD","MRS OKPEAJI","SATISFACTORY. YOU CAN DO BETTER.","0","100","5","5","5","5","5","5","5","5","5","5","submit","2021/2022","2nd Term"),
("826","11","1","0","JSS 1","","CHRISTIAN RELIGIOUS STUDIES","13","5","5","4","8","","","","","","","22","40","62","62","0","","","5th","C4","CREDIT","MRS OKPEAJI","SATISFACTORY. YOU CAN DO BETTER.","0","100","5","5","5","5","5","5","5","5","5","5","submit","2021/2022","2nd Term"),
("827","13","1","0","JSS 1","","CHRISTIAN RELIGIOUS STUDIES","13","2","2","3","10","","","","","","","17","31","48","48","0","","","7th","D7","PASS","MRS OKPEAJI","FAIR, TRY HARDER NEXT TIME","0","100","5","5","5","5","5","5","5","5","5","5","submit","2021/2022","2nd Term");
INSERT INTO result_subject VALUES
("828","14","1","0","JSS 1","","CHRISTIAN RELIGIOUS STUDIES","13","5","5","4","10","","","","","","","24","44","68","68","0","","","2nd","B3","GOOD","MRS OKPEAJI","SATISFACTORY. YOU CAN DO BETTER.","0","100","5","5","5","5","5","5","5","5","5","5","submit","2021/2022","2nd Term"),
("829","2","1","0","JSS 1","","CIVIC EDUCATION","10","10","9","9","6","","","","","","","34","38","72","72","0","","","6th","B2","VERY GOOD","MRS OKPEAJI","VERY GOOD, WELL DONE","0","100","5","5","5","5","5","5","5","5","5","5","submit","2021/2022","2nd Term"),
("830","35","1","0","JSS 1","","CIVIC EDUCATION","10","7","6","5","7","","","","","","","25","33","58","58","0","","","7th","C5","CREDIT","MRS OKPEAJI","GOOD WORK. WORK HARDER","0","100","5","5","5","5","5","5","5","5","5","5","submit","2021/2022","2nd Term"),
("831","1","1","0","JSS 1","","CIVIC EDUCATION","10","7","9","9","6","","","","","","","31","46","77","77","0","","","5th","B2","VERY GOOD","MRS OKPEAJI","VERY GOOD, WELL DONE","0","100","5","5","5","5","5","5","5","5","5","5","submit","2021/2022","2nd Term"),
("832","3","1","0","JSS 1","","CIVIC EDUCATION","10","4","4","4","5","","","","","","","17","20","37","37","0","","","13th","F9","FAIL","MRS OKPEAJI","FAIR, YOU CAN DO BETTER","0","100","5","5","5","5","5","5","5","5","5","5","submit","2021/2022","2nd Term"),
("833","4","1","0","JSS 1","","CIVIC EDUCATION","10","9","8","8","9","","","","","","","34","46","80","80","0","","","2nd","A1","EXCELLENT","MRS OKPEAJI","EXCELLENT PERFORMANCE, KEEP IT UP","0","100","5","5","5","5","5","5","5","5","5","5","submit","2021/2022","2nd Term"),
("834","6","1","0","JSS 1","","CIVIC EDUCATION","10","5","2","2","8","","","","","","","17","23","40","40","0","","","11th","E8","POOR","MRS OKPEAJI","FAIR, TRY HARDER NEXT TIME","0","100","5","5","5","5","5","5","5","5","5","5","submit","2021/2022","2nd Term"),
("835","7","1","0","JSS 1","","CIVIC EDUCATION","10","7","4","3","1","","","","","","","15","19","34","34","0","","","14th","F9","FAIL","MRS OKPEAJI","FAIR, YOU CAN DO BETTER","0","100","5","5","5","5","5","5","5","5","5","5","submit","2021/2022","2nd Term"),
("836","8","1","0","JSS 1","","CIVIC EDUCATION","10","4","4","4","1","","","","","","","13","25","38","38","0","","","12th","F9","FAIL","MRS OKPEAJI","FAIR, YOU CAN DO BETTER","0","100","5","5","5","5","5","5","5","5","5","5","submit","2021/2022","2nd Term"),
("837","9","1","0","JSS 1","","CIVIC EDUCATION","10","5","3","4","8","","","","","","","20","22","42","42","0","","","9th","E8","POOR","MRS OKPEAJI","FAIR, TRY HARDER NEXT TIME","0","100","5","5","5","5","5","5","5","5","5","5","submit","2021/2022","2nd Term"),
("838","10","1","0","JSS 1","","CIVIC EDUCATION","10","9","9","8","7","","","","","","","33","45","78","78","0","","","3rd","B2","VERY GOOD","MRS OKPEAJI","VERY GOOD, WELL DONE","0","100","5","5","5","5","5","5","5","5","5","5","submit","2021/2022","2nd Term"),
("839","11","1","0","JSS 1","","CIVIC EDUCATION","10","5","5","5","7","","","","","","","22","30","52","52","0","","","8th","C6","CREDIT","MRS OKPEAJI","GOOD WORK. WORK HARDER","0","100","5","5","5","5","5","5","5","5","5","5","submit","2021/2022","2nd Term"),
("840","13","1","0","JSS 1","","CIVIC EDUCATION","10","6","4","5","7","","","","","","","22","20","42","42","0","","","9th","E8","POOR","MRS OKPEAJI","FAIR, TRY HARDER NEXT TIME","0","100","5","5","5","5","5","5","5","5","5","5","submit","2021/2022","2nd Term"),
("841","5","1","0","JSS 1","","CIVIC EDUCATION","10","8","7","7","7","","","","","","","29","49","78","78","0","","","3rd","B2","VERY GOOD","MRS OKPEAJI","VERY GOOD, WELL DONE","0","100","5","5","5","5","5","5","5","5","5","5","submit","2021/2022","2nd Term"),
("842","14","1","0","JSS 1","","CIVIC EDUCATION","10","8","9","9","9","","","","","","","35","55","90","90","0","","","1st","A1","DISTINCTION","MRS OKPEAJI","EXCEPTIONAL WORK. WONDERFULLY DONE.","0","100","5","5","5","5","5","5","5","5","5","5","submit","2021/2022","2nd Term"),
("843","2","1","0","JSS 1","","SECURITY EDUCATION","11","9","8","10","10","","","","","","","37","45","82","82","0","","","5th","A1","EXCELLENT","MRS OKPEAJI","EXCELLENT PERFORMANCE, KEEP IT UP","0","100","5","5","5","5","5","5","5","5","5","5","submit","2021/2022","2nd Term"),
("844","35","1","0","JSS 1","","SECURITY EDUCATION","11","7","7","7","10","","","","","","","31","40","71","71","0","","","6th","B2","VERY GOOD","MRS OKPEAJI","VERY GOOD, WELL DONE","0","100","5","5","5","5","5","5","5","5","5","5","submit","2021/2022","2nd Term"),
("845","1","1","0","JSS 1","","SECURITY EDUCATION","11","6","6","6","10","","","","","","","28","35","63","63","0","","","8th","C4","CREDIT","MRS OKPEAJI","SATISFACTORY. YOU CAN DO BETTER.","0","100","5","5","5","5","5","5","5","5","5","5","submit","2021/2022","2nd Term"),
("846","3","1","0","JSS 1","","SECURITY EDUCATION","11","6","3","3","10","","","","","","","22","27","49","49","0","","","11th","D7","PASS","MRS OKPEAJI","FAIR, TRY HARDER NEXT TIME","0","100","5","5","5","5","5","5","5","5","5","5","submit","2021/2022","2nd Term"),
("847","4","1","0","JSS 1","","SECURITY EDUCATION","11","8","9","9","10","","","","","","","36","50","86","86","0","","","2nd","A1","EXCELLENT","MRS OKPEAJI","EXCELLENT PERFORMANCE, KEEP IT UP","0","100","5","5","5","5","5","5","5","5","5","5","submit","2021/2022","2nd Term"),
("848","6","1","0","JSS 1","","SECURITY EDUCATION","11","2","2","1","10","","","","","","","15","26","41","41","0","","","14th","E8","POOR","MRS OKPEAJI","FAIR, TRY HARDER NEXT TIME","0","100","5","5","5","5","5","5","5","5","5","5","submit","2021/2022","2nd Term"),
("849","7","1","0","JSS 1","","SECURITY EDUCATION","11","4","7","6","10","","","","","","","27","22","49","49","0","","","11th","D7","PASS","MRS OKPEAJI","FAIR, TRY HARDER NEXT TIME","0","100","5","5","5","5","5","5","5","5","5","5","submit","2021/2022","2nd Term"),
("850","8","1","0","JSS 1","","SECURITY EDUCATION","11","2","4","4","6","","","","","","","16","36","52","52","0","","","10th","C6","CREDIT","MRS OKPEAJI","GOOD WORK. WORK HARDER","0","100","5","5","5","5","5","5","5","5","5","5","submit","2021/2022","2nd Term"),
("851","9","1","0","JSS 1","","SECURITY EDUCATION","11","4","4","4","6","","","","","","","18","26","44","44","0","","","13th","E8","POOR","MRS OKPEAJI","FAIR, TRY HARDER NEXT TIME","0","100","5","5","5","5","5","5","5","5","5","5","submit","2021/2022","2nd Term"),
("852","10","1","0","JSS 1","","SECURITY EDUCATION","11","9","7","8","10","","","","","","","34","53","87","87","0","","","1st","A1","EXCELLENT","MRS OKPEAJI","EXCELLENT PERFORMANCE, KEEP IT UP","0","100","5","5","5","5","5","5","5","5","5","5","submit","2021/2022","2nd Term"),
("853","11","1","0","JSS 1","","SECURITY EDUCATION","11","7","6","6","10","","","","","","","29","36","65","65","0","","","7th","B3","GOOD","MRS OKPEAJI","SATISFACTORY. YOU CAN DO BETTER.","0","100","5","5","5","5","5","5","5","5","5","5","submit","2021/2022","2nd Term"),
("854","13","1","0","JSS 1","","SECURITY EDUCATION","11","7","4","3","10","","","","","","","24","31","55","55","0","","","9th","C5","CREDIT","MRS OKPEAJI","GOOD WORK. WORK HARDER","0","100","5","5","5","5","5","5","5","5","5","5","submit","2021/2022","2nd Term"),
("855","5","1","0","JSS 1","","SECURITY EDUCATION","11","7","8","8","10","","","","","","","33","50","83","83","0","","","4th","A1","EXCELLENT","MRS OKPEAJI","EXCELLENT PERFORMANCE, KEEP IT UP","0","100","5","5","5","5","5","5","5","5","5","5","submit","2021/2022","2nd Term"),
("856","14","1","0","JSS 1","","SECURITY EDUCATION","11","10","9","8","10","","","","","","","37","47","84","84","0","","","3rd","A1","EXCELLENT","MRS OKPEAJI","EXCELLENT PERFORMANCE, KEEP IT UP","0","100","5","5","5","5","5","5","5","5","5","5","submit","2021/2022","2nd Term"),
("857","2","1","0","JSS 1","","SOCIAL STUDIES","12","7","9","6","10","","","","","","","32","53","85","85","0","","","1st","A1","EXCELLENT","MRS OKPEAJI","EXCELLENT PERFORMANCE, KEEP IT UP","0","100","5","5","5","5","5","5","5","5","5","5","submit","2021/2022","2nd Term"),
("858","35","1","0","JSS 1","","SOCIAL STUDIES","12","3","4","7","10","","","","","","","24","41","65","65","0","","","6th","B3","GOOD","MRS OKPEAJI","SATISFACTORY. YOU CAN DO BETTER.","0","100","5","5","5","5","5","5","5","5","5","5","submit","2021/2022","2nd Term"),
("859","1","1","0","JSS 1","","SOCIAL STUDIES","12","3","5","6","9","","","","","","","23","31","54","54","0","","","9th","C6","CREDIT","MRS OKPEAJI","GOOD WORK. WORK HARDER","0","100","5","5","5","5","5","5","5","5","5","5","submit","2021/2022","2nd Term"),
("860","3","1","0","JSS 1","","SOCIAL STUDIES","12","4","2","6","10","","","","","","","22","22","44","44","0","","","10th","E8","POOR","MRS OKPEAJI","FAIR, TRY HARDER NEXT TIME","0","100","5","5","5","5","5","5","5","5","5","5","submit","2021/2022","2nd Term"),
("861","4","1","0","JSS 1","","SOCIAL STUDIES","12","6","7","10","10","","","","","","","33","49","82","82","0","","","2nd","A1","EXCELLENT","MRS OKPEAJI","EXCELLENT PERFORMANCE, KEEP IT UP","0","100","5","5","5","5","5","5","5","5","5","5","submit","2021/2022","2nd Term"),
("862","6","1","0","JSS 1","","SOCIAL STUDIES","12","2","1","7","10","","","","","","","20","23","43","43","0","","","11th","E8","POOR","MRS OKPEAJI","FAIR, TRY HARDER NEXT TIME","0","100","5","5","5","5","5","5","5","5","5","5","submit","2021/2022","2nd Term"),
("863","7","1","0","JSS 1","","SOCIAL STUDIES","12","1","1","1","5","","","","","","","8","27","35","35","0","","","14th","F9","FAIL","MRS OKPEAJI","FAIR, YOU CAN DO BETTER","0","100","5","5","5","5","5","5","5","5","5","5","submit","2021/2022","2nd Term"),
("864","8","1","0","JSS 1","","SOCIAL STUDIES","12","3","3","1","9","","","","","","","16","25","41","41","0","","","12th","E8","POOR","MRS OKPEAJI","FAIR, TRY HARDER NEXT TIME","0","100","5","5","5","5","5","5","5","5","5","5","submit","2021/2022","2nd Term"),
("865","9","1","0","JSS 1","","SOCIAL STUDIES","12","2","1","10","7","","","","","","","20","20","40","40","0","","","13th","E8","POOR","MRS OKPEAJI","FAIR, TRY HARDER NEXT TIME","0","100","5","5","5","5","5","5","5","5","5","5","submit","2021/2022","2nd Term"),
("866","10","1","0","JSS 1","","SOCIAL STUDIES","12","5","3","5","10","","","","","","","23","39","62","62","0","","","7th","C4","CREDIT","MRS OKPEAJI","SATISFACTORY. YOU CAN DO BETTER.","0","100","5","5","5","5","5","5","5","5","5","5","submit","2021/2022","2nd Term"),
("867","11","1","0","JSS 1","","SOCIAL STUDIES","12","8","7","8","9","","","","","","","32","48","80","80","0","","","4th","A1","EXCELLENT","MRS OKPEAJI","EXCELLENT PERFORMANCE, KEEP IT UP","0","100","5","5","5","5","5","5","5","5","5","5","submit","2021/2022","2nd Term"),
("868","13","1","0","JSS 1","","SOCIAL STUDIES","12","7","3","9","10","","","","","","","29","33","62","62","0","","","7th","C4","CREDIT","MRS OKPEAJI","SATISFACTORY. YOU CAN DO BETTER.","0","100","5","5","5","5","5","5","5","5","5","5","submit","2021/2022","2nd Term"),
("869","5","1","0","JSS 1","","SOCIAL STUDIES","12","5","6","8","10","","","","","","","29","47","76","76","0","","","5th","B2","VERY GOOD","MRS OKPEAJI","VERY GOOD, WELL DONE","0","100","5","5","5","5","5","5","5","5","5","5","submit","2021/2022","2nd Term"),
("870","14","1","0","JSS 1","","SOCIAL STUDIES","12","6","7","9","10","","","","","","","32","50","82","82","0","","","2nd","A1","EXCELLENT","MRS OKPEAJI","EXCELLENT PERFORMANCE, KEEP IT UP","0","100","5","5","5","5","5","5","5","5","5","5","submit","2021/2022","2nd Term"),
("871","15","2","0","JSS 2","","CHRISTIAN RELIGIOUS STUDIES","13","8","9","8","10","","","","","","","35","35","70","70","0","","","9th","B2","VERY GOOD","MRS OKPEAJI","VERY GOOD, WELL DONE","0","100","5","5","5","5","5","5","5","5","5","5","submit","2021/2022","2nd Term"),
("872","16","2","0","JSS 2","","CHRISTIAN RELIGIOUS STUDIES","13","10","10","9","10","","","","","","","39","44","83","83","0","","","4th","A1","EXCELLENT","MRS OKPEAJI","EXCELLENT PERFORMANCE, KEEP IT UP","0","100","5","5","5","5","5","5","5","5","5","5","submit","2021/2022","2nd Term"),
("873","17","2","0","JSS 2","","CHRISTIAN RELIGIOUS STUDIES","13","7","10","8","10","","","","","","","35","44","79","79","0","","","6th","B2","VERY GOOD","MRS OKPEAJI","VERY GOOD, WELL DONE","0","100","5","5","5","5","5","5","5","5","5","5","submit","2021/2022","2nd Term"),
("874","18","2","0","JSS 2","","CHRISTIAN RELIGIOUS STUDIES","13","10","10","9","10","","","","","","","39","58","97","97","0","","","1st","A1","DISTINCTION","MRS OKPEAJI","EXCEPTIONAL WORK. WONDERFULLY DONE.","0","100","5","5","5","5","5","5","5","5","5","5","submit","2021/2022","2nd Term"),
("875","19","2","0","JSS 2","","CHRISTIAN RELIGIOUS STUDIES","13","8","8","7","10","","","","","","","33","48","81","81","0","","","5th","A1","EXCELLENT","MRS OKPEAJI","EXCELLENT PERFORMANCE, KEEP IT UP","0","100","5","5","5","5","5","5","5","5","5","5","submit","2021/2022","2nd Term"),
("876","20","2","0","JSS 2","","CHRISTIAN RELIGIOUS STUDIES","13","9","8","9","10","","","","","","","36","48","84","84","0","","","3rd","A1","EXCELLENT","MRS OKPEAJI","EXCELLENT PERFORMANCE, KEEP IT UP","0","100","5","5","5","5","5","5","5","5","5","5","submit","2021/2022","2nd Term"),
("877","21","2","0","JSS 2","","CHRISTIAN RELIGIOUS STUDIES","13","8","9","7","9","","","","","","","33","39","72","72","0","","","8th","B2","VERY GOOD","MRS OKPEAJI","VERY GOOD, WELL DONE","0","100","5","5","5","5","5","5","5","5","5","5","submit","2021/2022","2nd Term"),
("878","23","2","0","JSS 2","","CHRISTIAN RELIGIOUS STUDIES","13","8","8","8","10","","","","","","","34","44","78","78","0","","","7th","B2","VERY GOOD","MRS OKPEAJI","VERY GOOD, WELL DONE","0","100","5","5","5","5","5","5","5","5","5","5","submit","2021/2022","2nd Term"),
("879","34","2","0","JSS 2","","CHRISTIAN RELIGIOUS STUDIES","13","10","8","8","10","","","","","","","36","51","87","87","0","","","2nd","A1","EXCELLENT","MRS OKPEAJI","EXCELLENT PERFORMANCE, KEEP IT UP","0","100","5","5","5","5","5","5","5","5","5","5","submit","2021/2022","2nd Term"),
("880","15","2","0","JSS 2","","CIVIC EDUCATION","10","6","7","7","10","","","","","","","30","40","70","70","0","","","6th","B2","VERY GOOD","MRS OKPEAJI","VERY GOOD, WELL DONE","0","100","5","5","5","5","5","5","5","5","5","5","submit","2021/2022","2nd Term"),
("881","16","2","0","JSS 2","","CIVIC EDUCATION","10","7","9","10","10","","","","","","","36","43","79","79","0","","","3rd","B2","VERY GOOD","MRS OKPEAJI","VERY GOOD, WELL DONE","0","100","5","5","5","5","5","5","5","5","5","5","submit","2021/2022","2nd Term"),
("882","17","2","0","JSS 2","","CIVIC EDUCATION","10","5","5","4","10","","","","","","","24","43","67","67","0","","","7th","B3","GOOD","MRS OKPEAJI","SATISFACTORY. YOU CAN DO BETTER.","0","100","5","5","5","5","5","5","5","5","5","5","submit","2021/2022","2nd Term"),
("883","18","2","0","JSS 2","","CIVIC EDUCATION","10","8","10","9","10","","","","","","","37","48","85","85","0","","","1st","A1","EXCELLENT","MRS OKPEAJI","EXCELLENT PERFORMANCE, KEEP IT UP","0","100","5","5","5","5","5","5","5","5","5","5","submit","2021/2022","2nd Term"),
("884","19","2","0","JSS 2","","CIVIC EDUCATION","10","6","4","7","9","","","","","","","26","35","61","61","0","","","8th","C4","CREDIT","MRS OKPEAJI","SATISFACTORY. YOU CAN DO BETTER.","0","100","5","5","5","5","5","5","5","5","5","5","submit","2021/2022","2nd Term"),
("885","20","2","0","JSS 2","","CIVIC EDUCATION","10","6","6","6","10","","","","","","","28","45","73","73","0","","","4th","B2","VERY GOOD","MRS OKPEAJI","VERY GOOD, WELL DONE","0","100","5","5","5","5","5","5","5","5","5","5","submit","2021/2022","2nd Term"),
("886","21","2","0","JSS 2","","CIVIC EDUCATION","10","5","4","3","9","","","","","","","21","34","55","55","0","","","9th","C5","CREDIT","MRS OKPEAJI","GOOD WORK. WORK HARDER","0","100","5","5","5","5","5","5","5","5","5","5","submit","2021/2022","2nd Term"),
("887","22","2","0","JSS 2","","CIVIC EDUCATION","10","7","2","2","5","","","","","","","16","29","45","45","0","","","10th","D7","PASS","MRS OKPEAJI","FAIR, TRY HARDER NEXT TIME","0","100","5","5","5","5","5","5","5","5","5","5","submit","2021/2022","2nd Term"),
("888","23","2","0","JSS 2","","CIVIC EDUCATION","10","5","6","7","10","","","","","","","28","44","72","72","0","","","5th","B2","VERY GOOD","MRS OKPEAJI","VERY GOOD, WELL DONE","0","100","5","5","5","5","5","5","5","5","5","5","submit","2021/2022","2nd Term"),
("889","34","2","0","JSS 2","","CIVIC EDUCATION","10","7","8","9","10","","","","","","","34","51","85","85","0","","","1st","A1","EXCELLENT","MRS OKPEAJI","EXCELLENT PERFORMANCE, KEEP IT UP","0","100","5","5","5","5","5","5","5","5","5","5","submit","2021/2022","2nd Term"),
("890","15","2","0","JSS 2","","SECURITY EDUCATION","11","6","9","8","5","","","","","","","28","43","71","71","0","","","8th","B2","VERY GOOD","MRS OKPEAJI","VERY GOOD, WELL DONE","0","100","5","5","5","5","5","5","5","5","5","5","submit","2021/2022","2nd Term"),
("891","16","2","0","JSS 2","","SECURITY EDUCATION","11","8","8","9","10","","","","","","","35","47","82","82","0","","","2nd","A1","EXCELLENT","MRS OKPEAJI","EXCELLENT PERFORMANCE, KEEP IT UP","0","100","5","5","5","5","5","5","5","5","5","5","submit","2021/2022","2nd Term"),
("892","17","2","0","JSS 2","","SECURITY EDUCATION","11","8","8","6","8","","","","","","","30","45","75","75","0","","","6th","B2","VERY GOOD","MRS OKPEAJI","VERY GOOD, WELL DONE","0","100","5","5","5","5","5","5","5","5","5","5","submit","2021/2022","2nd Term"),
("893","18","2","0","JSS 2","","SECURITY EDUCATION","11","10","8","9","8","","","","","","","35","49","84","84","0","","","1st","A1","EXCELLENT","MRS OKPEAJI","EXCELLENT PERFORMANCE, KEEP IT UP","0","100","5","5","5","5","5","5","5","5","5","5","submit","2021/2022","2nd Term"),
("894","19","2","0","JSS 2","","SECURITY EDUCATION","11","7","9","8","7","","","","","","","31","45","76","76","0","","","4th","B2","VERY GOOD","MRS OKPEAJI","VERY GOOD, WELL DONE","0","100","5","5","5","5","5","5","5","5","5","5","submit","2021/2022","2nd Term"),
("895","20","2","0","JSS 2","","SECURITY EDUCATION","11","8","8","9","6","","","","","","","31","44","75","75","0","","","6th","B2","VERY GOOD","MRS OKPEAJI","VERY GOOD, WELL DONE","0","100","5","5","5","5","5","5","5","5","5","5","submit","2021/2022","2nd Term"),
("896","21","2","0","JSS 2","","SECURITY EDUCATION","11","4","8","8","7","","","","","","","27","29","56","56","0","","","10th","C5","CREDIT","MRS OKPEAJI","GOOD WORK. WORK HARDER","0","100","5","5","5","5","5","5","5","5","5","5","submit","2021/2022","2nd Term"),
("897","22","2","0","JSS 2","","SECURITY EDUCATION","11","6","7","7","6","","","","","","","26","37","63","63","0","","","9th","C4","CREDIT","MRS OKPEAJI","SATISFACTORY. YOU CAN DO BETTER.","0","100","5","5","5","5","5","5","5","5","5","5","submit","2021/2022","2nd Term"),
("898","23","2","0","JSS 2","","SECURITY EDUCATION","11","10","8","7","7","","","","","","","32","44","76","76","0","","","4th","B2","VERY GOOD","MRS OKPEAJI","VERY GOOD, WELL DONE","0","100","5","5","5","5","5","5","5","5","5","5","submit","2021/2022","2nd Term"),
("899","34","2","0","JSS 2","","SECURITY EDUCATION","11","9","10","9","10","","","","","","","38","44","82","82","0","","","2nd","A1","EXCELLENT","MRS OKPEAJI","EXCELLENT PERFORMANCE, KEEP IT UP","0","100","5","5","5","5","5","5","5","5","5","5","submit","2021/2022","2nd Term"),
("900","15","2","0","JSS 2","","SOCIAL STUDIES","12","4","6","6","10","","","","","","","26","41","67","67","0","","","8th","B3","GOOD","MRS OKPEAJI","SATISFACTORY. YOU CAN DO BETTER.","0","100","5","5","5","5","5","5","5","5","5","5","submit","2021/2022","2nd Term"),
("901","16","2","0","JSS 2","","SOCIAL STUDIES","12","8","8","8","10","","","","","","","34","48","82","82","0","","","2nd","A1","EXCELLENT","MRS OKPEAJI","EXCELLENT PERFORMANCE, KEEP IT UP","0","100","5","5","5","5","5","5","5","5","5","5","submit","2021/2022","2nd Term"),
("902","17","2","0","JSS 2","","SOCIAL STUDIES","12","6","6","7","10","","","","","","","29","43","72","72","0","","","7th","B2","VERY GOOD","MRS OKPEAJI","VERY GOOD, WELL DONE","0","100","5","5","5","5","5","5","5","5","5","5","submit","2021/2022","2nd Term"),
("903","18","2","0","JSS 2","","SOCIAL STUDIES","12","10","9","10","10","","","","","","","39","56","95","95","0","","","1st","A1","DISTINCTION","MRS OKPEAJI","EXCEPTIONAL WORK. WONDERFULLY DONE.","0","100","5","5","5","5","5","5","5","5","5","5","submit","2021/2022","2nd Term"),
("904","19","2","0","JSS 2","","SOCIAL STUDIES","12","7","8","8","9","","","","","","","32","49","81","81","0","","","3rd","A1","EXCELLENT","MRS OKPEAJI","EXCELLENT PERFORMANCE, KEEP IT UP","0","100","5","5","5","5","5","5","5","5","5","5","submit","2021/2022","2nd Term"),
("905","20","2","0","JSS 2","","SOCIAL STUDIES","12","8","7","8","10","","","","","","","33","47","80","80","0","","","4th","A1","EXCELLENT","MRS OKPEAJI","EXCELLENT PERFORMANCE, KEEP IT UP","0","100","5","5","5","5","5","5","5","5","5","5","submit","2021/2022","2nd Term"),
("906","21","2","0","JSS 2","","SOCIAL STUDIES","12","7","6","6","8","","","","","","","27","36","63","63","0","","","9th","C4","CREDIT","MRS OKPEAJI","SATISFACTORY. YOU CAN DO BETTER.","0","100","5","5","5","5","5","5","5","5","5","5","submit","2021/2022","2nd Term"),
("907","22","2","0","JSS 2","","SOCIAL STUDIES","12","4","4","6","10","","","","","","","24","37","61","61","0","","","10th","C4","CREDIT","MRS OKPEAJI","SATISFACTORY. YOU CAN DO BETTER.","0","100","5","5","5","5","5","5","5","5","5","5","submit","2021/2022","2nd Term"),
("908","23","2","0","JSS 2","","SOCIAL STUDIES","12","6","6","7","10","","","","","","","29","46","75","75","0","","","6th","B2","VERY GOOD","MRS OKPEAJI","VERY GOOD, WELL DONE","0","100","5","5","5","5","5","5","5","5","5","5","submit","2021/2022","2nd Term"),
("909","34","2","0","JSS 2","","SOCIAL STUDIES","12","8","9","9","10","","","","","","","36","42","78","78","0","","","5th","B2","VERY GOOD","MRS OKPEAJI","VERY GOOD, WELL DONE","0","100","5","5","5","5","5","5","5","5","5","5","submit","2021/2022","2nd Term"),
("910","26","3","0","JSS 3","","CHRISTIAN RELIGIOUS STUDIES","13","8","9","9","10","","","","","","","36","36","72","72","0","","","1st","B2","VERY GOOD","MRS OKPEAJI","VERY GOOD, WELL DONE","0","100","5","5","5","5","5","5","5","5","5","5","submit","2021/2022","2nd Term"),
("911","27","3","0","JSS 3","","CHRISTIAN RELIGIOUS STUDIES","13","5","4","4","10","","","","","","","23","22","45","45","0","","","5th","D7","PASS","MRS OKPEAJI","FAIR, TRY HARDER NEXT TIME","0","100","5","5","5","5","5","5","5","5","5","5","submit","2021/2022","2nd Term"),
("912","30","3","0","JSS 3","","CHRISTIAN RELIGIOUS STUDIES","13","3","2","3","9","","","","","","","17","23","40","40","0","","","7th","E8","POOR","MRS OKPEAJI","FAIR, TRY HARDER NEXT TIME","0","100","5","5","5","5","5","5","5","5","5","5","submit","2021/2022","2nd Term"),
("913","33","3","0","JSS 3","","CHRISTIAN RELIGIOUS STUDIES","13","4","7","7","7","","","","","","","25","29","54","54","0","","","4th","C6","CREDIT","MRS OKPEAJI","GOOD WORK. WORK HARDER","0","100","5","5","5","5","5","5","5","5","5","5","submit","2021/2022","2nd Term"),
("914","31","3","0","JSS 3","","CHRISTIAN RELIGIOUS STUDIES","13","4","2","3","7","","","","","","","16","28","44","44","0","","","6th","E8","POOR","MRS OKPEAJI","FAIR, TRY HARDER NEXT TIME","0","100","5","5","5","5","5","5","5","5","5","5","submit","2021/2022","2nd Term"),
("915","28","3","0","JSS 3","","CHRISTIAN RELIGIOUS STUDIES","13","4","9","7","8","","","","","","","28","37","65","65","0","","","3rd","B3","GOOD","MRS OKPEAJI","SATISFACTORY. YOU CAN DO BETTER.","0","100","5","5","5","5","5","5","5","5","5","5","submit","2021/2022","2nd Term"),
("916","32","3","0","JSS 3","","CHRISTIAN RELIGIOUS STUDIES","13","9","8","7","10","","","","","","","34","36","70","70","0","","","2nd","B2","VERY GOOD","MRS OKPEAJI","VERY GOOD, WELL DONE","0","100","5","5","5","5","5","5","5","5","5","5","submit","2021/2022","2nd Term"),
("917","26","3","0","JSS 3","","CIVIC EDUCATION","10","9","10","9","10","","","","","","","38","50","88","88","0","","","2nd","A1","EXCELLENT","MRS OKPEAJI","EXCELLENT PERFORMANCE, KEEP IT UP","0","100","5","5","5","5","5","5","5","5","5","5","submit","2021/2022","2nd Term"),
("918","27","3","0","JSS 3","","CIVIC EDUCATION","10","6","7","4","9","","","","","","","26","36","62","62","0","","","6th","C4","CREDIT","MRS OKPEAJI","SATISFACTORY. YOU CAN DO BETTER.","0","100","5","5","5","5","5","5","5","5","5","5","submit","2021/2022","2nd Term"),
("919","29","3","0","JSS 3","","CIVIC EDUCATION","10","8","8","7","10","","","","","","","33","43","76","76","0","","","4th","B2","VERY GOOD","MRS OKPEAJI","VERY GOOD, WELL DONE","0","100","5","5","5","5","5","5","5","5","5","5","submit","2021/2022","2nd Term"),
("920","30","3","0","JSS 3","","CIVIC EDUCATION","10","2","2","2","10","","","","","","","16","19","35","35","0","","","8th","F9","FAIL","MRS OKPEAJI","FAIR, YOU CAN DO BETTER","0","100","5","5","5","5","5","5","5","5","5","5","submit","2021/2022","2nd Term"),
("921","33","3","0","JSS 3","","CIVIC EDUCATION","10","8","6","8","10","","","","","","","32","32","64","64","0","","","5th","C4","CREDIT","MRS OKPEAJI","SATISFACTORY. YOU CAN DO BETTER.","0","100","5","5","5","5","5","5","5","5","5","5","submit","2021/2022","2nd Term"),
("922","31","3","0","JSS 3","","CIVIC EDUCATION","10","6","5","5","9","","","","","","","25","35","60","60","0","","","7th","C4","CREDIT","MRS OKPEAJI","SATISFACTORY. YOU CAN DO BETTER.","0","100","5","5","5","5","5","5","5","5","5","5","submit","2021/2022","2nd Term"),
("923","28","3","0","JSS 3","","CIVIC EDUCATION","10","8","7","7","10","","","","","","","32","51","83","83","0","","","3rd","A1","EXCELLENT","MRS OKPEAJI","EXCELLENT PERFORMANCE, KEEP IT UP","0","100","5","5","5","5","5","5","5","5","5","5","submit","2021/2022","2nd Term"),
("924","32","3","0","JSS 3","","CIVIC EDUCATION","10","10","10","9","10","","","","","","","39","52","91","91","0","","","1st","A1","DISTINCTION","MRS OKPEAJI","EXCEPTIONAL WORK. WONDERFULLY DONE.","0","100","5","5","5","5","5","5","5","5","5","5","submit","2021/2022","2nd Term"),
("925","2","1","0","JSS 1","","CULTURAL AND CREATIVE ARTS","2","4","10","8","10","","","","","","","32","42","74","74","0","","","1st","B2","VERY GOOD","NWACHUKWU MERCY","VERY GOOD, WELL DONE","0","100","5","5","5","5","5","5","5","5","5","5","submit","2021/2022","2nd Term"),
("926","35","1","0","JSS 1","","CULTURAL AND CREATIVE ARTS","2","2","10","5","10","","","","","","","27","31","58","58","0","","","7th","C5","CREDIT","NWACHUKWU MERCY","GOOD WORK. WORK HARDER","0","100","5","5","5","5","5","5","5","5","5","5","submit","2021/2022","2nd Term"),
("927","1","1","0","JSS 1","","CULTURAL AND CREATIVE ARTS","2","4","10","4","10","","","","","","","28","38","66","66","0","","","3rd","B3","GOOD","NWACHUKWU MERCY","SATISFACTORY. YOU CAN DO BETTER.","0","100","5","5","5","5","5","5","5","5","5","5","submit","2021/2022","2nd Term");
INSERT INTO result_subject VALUES
("928","3","1","0","JSS 1","","CULTURAL AND CREATIVE ARTS","2","3","3","4","10","","","","","","","20","31","51","51","0","","","10th","C6","CREDIT","NWACHUKWU MERCY","GOOD WORK. WORK HARDER","0","100","5","5","5","5","5","5","5","5","5","5","submit","2021/2022","2nd Term"),
("929","4","1","0","JSS 1","","CULTURAL AND CREATIVE ARTS","2","3","2","7","10","","","","","","","22","43","65","65","0","","","5th","B3","GOOD","NWACHUKWU MERCY","SATISFACTORY. YOU CAN DO BETTER.","0","100","5","5","5","5","5","5","5","5","5","5","submit","2021/2022","2nd Term"),
("930","6","1","0","JSS 1","","CULTURAL AND CREATIVE ARTS","2","2","10","4","10","","","","","","","26","19","45","45","0","","","12th","D7","PASS","NWACHUKWU MERCY","FAIR, TRY HARDER NEXT TIME","0","100","5","5","5","5","5","5","5","5","5","5","submit","2021/2022","2nd Term"),
("931","7","1","0","JSS 1","","CULTURAL AND CREATIVE ARTS","2","2","2","4","10","","","","","","","18","30","48","48","0","","","11th","D7","PASS","NWACHUKWU MERCY","FAIR, TRY HARDER NEXT TIME","0","100","5","5","5","5","5","5","5","5","5","5","submit","2021/2022","2nd Term"),
("932","8","1","0","JSS 1","","CULTURAL AND CREATIVE ARTS","2","2","2","4","10","","","","","","","18","17","35","35","0","","","14th","F9","FAIL","NWACHUKWU MERCY","FAIR, YOU CAN DO BETTER","0","100","5","5","5","5","5","5","5","5","5","5","submit","2021/2022","2nd Term"),
("933","9","1","0","JSS 1","","CULTURAL AND CREATIVE ARTS","2","4","10","4","10","","","","","","","28","27","55","55","0","","","8th","C5","CREDIT","NWACHUKWU MERCY","GOOD WORK. WORK HARDER","0","100","5","5","5","5","5","5","5","5","5","5","submit","2021/2022","2nd Term"),
("934","10","1","0","JSS 1","","CULTURAL AND CREATIVE ARTS","2","4","10","4","10","","","","","","","28","38","66","66","0","","","3rd","B3","GOOD","NWACHUKWU MERCY","SATISFACTORY. YOU CAN DO BETTER.","0","100","5","5","5","5","5","5","5","5","5","5","submit","2021/2022","2nd Term"),
("935","11","1","0","JSS 1","","CULTURAL AND CREATIVE ARTS","2","4","10","6","10","","","","","","","30","24","54","54","0","","","9th","C6","CREDIT","NWACHUKWU MERCY","GOOD WORK. WORK HARDER","0","100","5","5","5","5","5","5","5","5","5","5","submit","2021/2022","2nd Term"),
("936","13","1","0","JSS 1","","CULTURAL AND CREATIVE ARTS","2","3","10","4","10","","","","","","","27","17","44","44","0","","","13th","E8","POOR","NWACHUKWU MERCY","FAIR, TRY HARDER NEXT TIME","0","100","5","5","5","5","5","5","5","5","5","5","submit","2021/2022","2nd Term"),
("937","5","1","0","JSS 1","","CULTURAL AND CREATIVE ARTS","2","4","10","5","10","","","","","","","29","32","61","61","0","","","6th","C4","CREDIT","NWACHUKWU MERCY","SATISFACTORY. YOU CAN DO BETTER.","0","100","5","5","5","5","5","5","5","5","5","5","submit","2021/2022","2nd Term"),
("938","14","1","0","JSS 1","","CULTURAL AND CREATIVE ARTS","2","5","10","4","10","","","","","","","29","38","67","67","0","","","2nd","B3","GOOD","NWACHUKWU MERCY","SATISFACTORY. YOU CAN DO BETTER.","0","100","5","5","5","5","5","5","5","5","5","5","submit","2021/2022","2nd Term"),
("939","2","1","0","JSS 1","","ENGLISH LANGUAGE","1","8","3","7","10","","","","","","","28","47","75","75","0","","","6th","B2","VERY GOOD","NWACHUKWU MERCY","VERY GOOD, WELL DONE","0","100","5","5","5","5","5","5","5","5","5","5","submit","2021/2022","2nd Term"),
("940","35","1","0","JSS 1","","ENGLISH LANGUAGE","1","9","9","9","10","","","","","","","37","53","90","90","0","","","2nd","A1","DISTINCTION","NWACHUKWU MERCY","EXCEPTIONAL WORK. WONDERFULLY DONE.","0","100","5","5","5","5","5","5","5","5","5","5","submit","2021/2022","2nd Term"),
("941","1","1","0","JSS 1","","ENGLISH LANGUAGE","1","8","9","4","10","","","","","","","31","49","80","80","0","","","5th","A1","EXCELLENT","NWACHUKWU MERCY","EXCELLENT PERFORMANCE, KEEP IT UP","0","100","5","5","5","5","5","5","5","5","5","5","submit","2021/2022","2nd Term"),
("942","3","1","0","JSS 1","","ENGLISH LANGUAGE","1","3","7","4","10","","","","","","","24","28","52","52","0","","","11th","C6","CREDIT","NWACHUKWU MERCY","GOOD WORK. WORK HARDER","0","100","5","5","5","5","5","5","5","5","5","5","submit","2021/2022","2nd Term"),
("943","4","1","0","JSS 1","","ENGLISH LANGUAGE","1","9","10","8","10","","","","","","","37","52","89","89","0","","","3rd","A1","EXCELLENT","NWACHUKWU MERCY","EXCELLENT PERFORMANCE, KEEP IT UP","0","100","5","5","5","5","5","5","5","5","5","5","submit","2021/2022","2nd Term"),
("944","6","1","0","JSS 1","","ENGLISH LANGUAGE","1","3","3","3","8","","","","","","","17","10","27","27","0","","","14th","F9","FAIL","NWACHUKWU MERCY","FAIR, YOU CAN DO BETTER","0","100","5","5","5","5","5","5","5","5","5","5","submit","2021/2022","2nd Term"),
("945","7","1","0","JSS 1","","ENGLISH LANGUAGE","1","3","5","4","9","","","","","","","21","33","54","54","0","","","10th","C6","CREDIT","NWACHUKWU MERCY","GOOD WORK. WORK HARDER","0","100","5","5","5","5","5","5","5","5","5","5","submit","2021/2022","2nd Term"),
("946","8","1","0","JSS 1","","ENGLISH LANGUAGE","1","4","3","4","9","","","","","","","20","43","63","63","0","","","9th","C4","CREDIT","NWACHUKWU MERCY","SATISFACTORY. YOU CAN DO BETTER.","0","100","5","5","5","5","5","5","5","5","5","5","submit","2021/2022","2nd Term"),
("947","9","1","0","JSS 1","","ENGLISH LANGUAGE","1","3","4","4","10","","","","","","","21","25","46","46","0","","","13th","D7","PASS","NWACHUKWU MERCY","FAIR, TRY HARDER NEXT TIME","0","100","5","5","5","5","5","5","5","5","5","5","submit","2021/2022","2nd Term"),
("948","10","1","0","JSS 1","","ENGLISH LANGUAGE","1","3","5","8","10","","","","","","","26","49","75","75","0","","","6th","B2","VERY GOOD","NWACHUKWU MERCY","VERY GOOD, WELL DONE","0","100","5","5","5","5","5","5","5","5","5","5","submit","2021/2022","2nd Term"),
("949","11","1","0","JSS 1","","ENGLISH LANGUAGE","1","7","10","3","8","","","","","","","28","42","70","70","0","","","8th","B2","VERY GOOD","NWACHUKWU MERCY","VERY GOOD, WELL DONE","0","100","5","5","5","5","5","5","5","5","5","5","submit","2021/2022","2nd Term"),
("950","13","1","0","JSS 1","","ENGLISH LANGUAGE","1","3","5","5","10","","","","","","","23","28","51","51","0","","","12th","C6","CREDIT","NWACHUKWU MERCY","GOOD WORK. WORK HARDER","0","100","5","5","5","5","5","5","5","5","5","5","submit","2021/2022","2nd Term"),
("951","5","1","0","JSS 1","","ENGLISH LANGUAGE","1","9","8","7","10","","","","","","","34","52","86","86","0","","","4th","A1","EXCELLENT","NWACHUKWU MERCY","EXCELLENT PERFORMANCE, KEEP IT UP","0","100","5","5","5","5","5","5","5","5","5","5","submit","2021/2022","2nd Term"),
("952","14","1","0","JSS 1","","ENGLISH LANGUAGE","1","7","10","7","10","","","","","","","34","57","91","91","0","","","1st","A1","DISTINCTION","NWACHUKWU MERCY","EXCEPTIONAL WORK. WONDERFULLY DONE.","0","100","5","5","5","5","5","5","5","5","5","5","submit","2021/2022","2nd Term"),
("953","2","1","0","JSS 1","","PHYSICAL AND HEALTH EDUCATION","17","6","9","10","10","","","","","","","35","60","95","95","0","","","1st","A1","DISTINCTION","ONYEMECHI OGECHI","EXCEPTIONAL WORK. WONDERFULLY DONE.","0","100","5","5","5","5","5","5","5","5","5","5","submit","2021/2022","2nd Term"),
("954","35","1","0","JSS 1","","PHYSICAL AND HEALTH EDUCATION","17","3","9","10","8","","","","","","","30","44","74","74","0","","","5th","B2","VERY GOOD","ONYEMECHI OGECHI","VERY GOOD, WELL DONE","0","100","5","5","5","5","5","5","5","5","5","5","submit","2021/2022","2nd Term"),
("955","1","1","0","JSS 1","","PHYSICAL AND HEALTH EDUCATION","17","6","5","5","10","","","","","","","26","32","58","58","0","","","9th","C5","CREDIT","ONYEMECHI OGECHI","GOOD WORK. WORK HARDER","0","100","5","5","5","5","5","5","5","5","5","5","submit","2021/2022","2nd Term"),
("956","3","1","0","JSS 1","","PHYSICAL AND HEALTH EDUCATION","17","2","3","10","10","","","","","","","25","24","49","49","0","","","11th","D7","PASS","ONYEMECHI OGECHI","FAIR, TRY HARDER NEXT TIME","0","100","5","5","5","5","5","5","5","5","5","5","submit","2021/2022","2nd Term"),
("957","4","1","0","JSS 1","","PHYSICAL AND HEALTH EDUCATION","17","5","8","10","5","","","","","","","28","43","71","71","0","","","6th","B2","VERY GOOD","ONYEMECHI OGECHI","VERY GOOD, WELL DONE","0","100","5","5","5","5","5","5","5","5","5","5","submit","2021/2022","2nd Term"),
("958","6","1","0","JSS 1","","PHYSICAL AND HEALTH EDUCATION","17","2","2","5","8","","","","","","","17","30","47","47","0","","","14th","D7","PASS","ONYEMECHI OGECHI","FAIR, TRY HARDER NEXT TIME","0","100","5","5","5","5","5","5","5","5","5","5","submit","2021/2022","2nd Term"),
("959","7","1","0","JSS 1","","PHYSICAL AND HEALTH EDUCATION","17","5","6","6","8","","","","","","","25","24","49","49","0","","","11th","D7","PASS","ONYEMECHI OGECHI","FAIR, TRY HARDER NEXT TIME","0","100","5","5","5","5","5","5","5","5","5","5","submit","2021/2022","2nd Term"),
("960","8","1","0","JSS 1","","PHYSICAL AND HEALTH EDUCATION","17","5","6","10","8","","","","","","","29","30","59","59","0","","","8th","C5","CREDIT","ONYEMECHI OGECHI","GOOD WORK. WORK HARDER","0","100","5","5","5","5","5","5","5","5","5","5","submit","2021/2022","2nd Term"),
("961","9","1","0","JSS 1","","PHYSICAL AND HEALTH EDUCATION","17","5","5","5","7","","","","","","","22","26","48","48","0","","","13th","D7","PASS","ONYEMECHI OGECHI","FAIR, TRY HARDER NEXT TIME","0","100","5","5","5","5","5","5","5","5","5","5","submit","2021/2022","2nd Term"),
("962","10","1","0","JSS 1","","PHYSICAL AND HEALTH EDUCATION","17","6","9","10","8","","","","","","","33","50","83","83","0","","","2nd","A1","EXCELLENT","ONYEMECHI OGECHI","EXCELLENT PERFORMANCE, KEEP IT UP","0","100","5","5","5","5","5","5","5","5","5","5","submit","2021/2022","2nd Term"),
("963","11","1","0","JSS 1","","PHYSICAL AND HEALTH EDUCATION","17","2","6","10","8","","","","","","","26","40","66","66","0","","","7th","B3","GOOD","ONYEMECHI OGECHI","SATISFACTORY. YOU CAN DO BETTER.","0","100","5","5","5","5","5","5","5","5","5","5","submit","2021/2022","2nd Term"),
("964","13","1","0","JSS 1","","PHYSICAL AND HEALTH EDUCATION","17","8","6","10","10","","","","","","","34","24","58","58","0","","","9th","C5","CREDIT","ONYEMECHI OGECHI","GOOD WORK. WORK HARDER","0","100","5","5","5","5","5","5","5","5","5","5","submit","2021/2022","2nd Term"),
("965","5","1","0","JSS 1","","PHYSICAL AND HEALTH EDUCATION","17","9","8","10","10","","","","","","","37","44","81","81","0","","","4th","A1","EXCELLENT","ONYEMECHI OGECHI","EXCELLENT PERFORMANCE, KEEP IT UP","0","100","5","5","5","5","5","5","5","5","5","5","submit","2021/2022","2nd Term"),
("966","14","1","0","JSS 1","","PHYSICAL AND HEALTH EDUCATION","17","6","6","10","10","","","","","","","32","50","82","82","0","","","3rd","A1","EXCELLENT","ONYEMECHI OGECHI","EXCELLENT PERFORMANCE, KEEP IT UP","0","100","5","5","5","5","5","5","5","5","5","5","submit","2021/2022","2nd Term"),
("967","15","2","0","JSS 2","","PHYSICAL AND HEALTH EDUCATION","17","6","10","10","10","","","","","","","36","44","80","80","0","","","7th","A1","EXCELLENT","ONYEMECHI OGECHI","EXCELLENT PERFORMANCE, KEEP IT UP","0","100","5","5","5","5","5","5","5","5","5","5","submit","2021/2022","2nd Term"),
("968","16","2","0","JSS 2","","PHYSICAL AND HEALTH EDUCATION","17","10","9","10","10","","","","","","","39","52","91","91","0","","","1st","A1","DISTINCTION","ONYEMECHI OGECHI","EXCEPTIONAL WORK. WONDERFULLY DONE.","0","100","5","5","5","5","5","5","5","5","5","5","submit","2021/2022","2nd Term"),
("969","17","2","0","JSS 2","","PHYSICAL AND HEALTH EDUCATION","17","7","10","9","6","","","","","","","32","44","76","76","0","","","8th","B2","VERY GOOD","ONYEMECHI OGECHI","VERY GOOD, WELL DONE","0","100","5","5","5","5","5","5","5","5","5","5","submit","2021/2022","2nd Term"),
("970","18","2","0","JSS 2","","PHYSICAL AND HEALTH EDUCATION","17","10","9","9","10","","","","","","","38","53","91","91","0","","","1st","A1","DISTINCTION","ONYEMECHI OGECHI","EXCEPTIONAL WORK. WONDERFULLY DONE.","0","100","5","5","5","5","5","5","5","5","5","5","submit","2021/2022","2nd Term"),
("971","19","2","0","JSS 2","","PHYSICAL AND HEALTH EDUCATION","17","5","9","10","8","","","","","","","32","55","87","87","0","","","4th","A1","EXCELLENT","ONYEMECHI OGECHI","EXCELLENT PERFORMANCE, KEEP IT UP","0","100","5","5","5","5","5","5","5","5","5","5","submit","2021/2022","2nd Term"),
("972","20","2","0","JSS 2","","PHYSICAL AND HEALTH EDUCATION","17","10","8","10","10","","","","","","","38","48","86","86","0","","","5th","A1","EXCELLENT","ONYEMECHI OGECHI","EXCELLENT PERFORMANCE, KEEP IT UP","0","100","5","5","5","5","5","5","5","5","5","5","submit","2021/2022","2nd Term"),
("973","21","2","0","JSS 2","","PHYSICAL AND HEALTH EDUCATION","17","9","8","8","6","","","","","","","31","42","73","73","0","","","9th","B2","VERY GOOD","ONYEMECHI OGECHI","VERY GOOD, WELL DONE","0","100","5","5","5","5","5","5","5","5","5","5","submit","2021/2022","2nd Term"),
("974","22","2","0","JSS 2","","PHYSICAL AND HEALTH EDUCATION","17","8","8","8","5","","","","","","","29","37","66","66","0","","","10th","B3","GOOD","ONYEMECHI OGECHI","SATISFACTORY. YOU CAN DO BETTER.","0","100","5","5","5","5","5","5","5","5","5","5","submit","2021/2022","2nd Term"),
("975","23","2","0","JSS 2","","PHYSICAL AND HEALTH EDUCATION","17","8","9","10","10","","","","","","","37","51","88","88","0","","","3rd","A1","EXCELLENT","ONYEMECHI OGECHI","EXCELLENT PERFORMANCE, KEEP IT UP","0","100","5","5","5","5","5","5","5","5","5","5","submit","2021/2022","2nd Term"),
("976","34","2","0","JSS 2","","PHYSICAL AND HEALTH EDUCATION","17","8","10","9","8","","","","","","","35","51","86","86","0","","","5th","A1","EXCELLENT","ONYEMECHI OGECHI","EXCELLENT PERFORMANCE, KEEP IT UP","0","100","5","5","5","5","5","5","5","5","5","5","submit","2021/2022","2nd Term"),
("977","26","3","0","JSS 3","","PHYSICAL AND HEALTH EDUCATION","17","10","6","10","10","","","","","","","36","48","84","84","0","","","2nd","A1","EXCELLENT","ONYEMECHI OGECHI","EXCELLENT PERFORMANCE, KEEP IT UP","0","100","5","5","5","5","5","5","5","5","5","5","submit","2021/2022","2nd Term"),
("978","27","3","0","JSS 3","","PHYSICAL AND HEALTH EDUCATION","17","8","2","10","10","","","","","","","30","30","60","60","0","","","7th","C4","CREDIT","ONYEMECHI OGECHI","SATISFACTORY. YOU CAN DO BETTER.","0","100","5","5","5","5","5","5","5","5","5","5","submit","2021/2022","2nd Term"),
("979","29","3","0","JSS 3","","PHYSICAL AND HEALTH EDUCATION","17","2","5","10","8","","","","","","","25","45","70","70","0","","","5th","B2","VERY GOOD","ONYEMECHI OGECHI","VERY GOOD, WELL DONE","0","100","5","5","5","5","5","5","5","5","5","5","submit","2021/2022","2nd Term"),
("980","30","3","0","JSS 3","","PHYSICAL AND HEALTH EDUCATION","17","10","3","3","8","","","","","","","24","30","54","54","0","","","8th","C6","CREDIT","ONYEMECHI OGECHI","GOOD WORK. WORK HARDER","0","100","5","5","5","5","5","5","5","5","5","5","submit","2021/2022","2nd Term"),
("981","33","3","0","JSS 3","","PHYSICAL AND HEALTH EDUCATION","17","2","8","10","8","","","","","","","28","34","62","62","0","","","6th","C4","CREDIT","ONYEMECHI OGECHI","SATISFACTORY. YOU CAN DO BETTER.","0","100","5","5","5","5","5","5","5","5","5","5","submit","2021/2022","2nd Term"),
("982","31","3","0","JSS 3","","PHYSICAL AND HEALTH EDUCATION","17","8","5","10","10","","","","","","","33","40","73","73","0","","","4th","B2","VERY GOOD","ONYEMECHI OGECHI","VERY GOOD, WELL DONE","0","100","5","5","5","5","5","5","5","5","5","5","submit","2021/2022","2nd Term"),
("983","28","3","0","JSS 3","","PHYSICAL AND HEALTH EDUCATION","17","10","10","10","10","","","","","","","40","45","85","85","0","","","1st","A1","EXCELLENT","ONYEMECHI OGECHI","EXCELLENT PERFORMANCE, KEEP IT UP","0","100","5","5","5","5","5","5","5","5","5","5","submit","2021/2022","2nd Term"),
("984","32","3","0","JSS 3","","PHYSICAL AND HEALTH EDUCATION","17","8","7","10","10","","","","","","","35","44","79","79","0","","","3rd","B2","VERY GOOD","ONYEMECHI OGECHI","VERY GOOD, WELL DONE","0","100","5","5","5","5","5","5","5","5","5","5","submit","2021/2022","2nd Term"),
("985","2","1","0","JSS 1","","LITERATURE-IN-ENGLISH","3","7","5","6","10","","","","","","","28","34","62","62","0","","","7th","C4","CREDIT","NWACHUKWU MERCY","SATISFACTORY. YOU CAN DO BETTER.","0","100","5","5","5","5","5","5","5","5","5","5","submit","2021/2022","2nd Term"),
("986","35","1","0","JSS 1","","LITERATURE-IN-ENGLISH","3","8","5","4","10","","","","","","","27","38","65","65","0","","","6th","B3","GOOD","NWACHUKWU MERCY","SATISFACTORY. YOU CAN DO BETTER.","0","100","5","5","5","5","5","5","5","5","5","5","submit","2021/2022","2nd Term"),
("987","1","1","0","JSS 1","","LITERATURE-IN-ENGLISH","3","8","6","6","10","","","","","","","30","37","67","67","0","","","5th","B3","GOOD","NWACHUKWU MERCY","SATISFACTORY. YOU CAN DO BETTER.","0","100","5","5","5","5","5","5","5","5","5","5","submit","2021/2022","2nd Term"),
("988","3","1","0","JSS 1","","LITERATURE-IN-ENGLISH","3","3","4","3","10","","","","","","","20","30","50","50","0","","","12th","C6","CREDIT","NWACHUKWU MERCY","GOOD WORK. WORK HARDER","0","100","5","5","5","5","5","5","5","5","5","5","submit","2021/2022","2nd Term"),
("989","4","1","0","JSS 1","","LITERATURE-IN-ENGLISH","3","9","10","10","10","","","","","","","39","52","91","91","0","","","1st","A1","DISTINCTION","NWACHUKWU MERCY","EXCEPTIONAL WORK. WONDERFULLY DONE.","0","100","5","5","5","5","5","5","5","5","5","5","submit","2021/2022","2nd Term"),
("990","6","1","0","JSS 1","","LITERATURE-IN-ENGLISH","3","3","3","4","10","","","","","","","20","30","50","50","0","","","12th","C6","CREDIT","NWACHUKWU MERCY","GOOD WORK. WORK HARDER","0","100","5","5","5","5","5","5","5","5","5","5","submit","2021/2022","2nd Term"),
("991","7","1","0","JSS 1","","LITERATURE-IN-ENGLISH","3","8","5","5","10","","","","","","","28","30","58","58","0","","","9th","C5","CREDIT","NWACHUKWU MERCY","GOOD WORK. WORK HARDER","0","100","5","5","5","5","5","5","5","5","5","5","submit","2021/2022","2nd Term"),
("992","8","1","0","JSS 1","","LITERATURE-IN-ENGLISH","3","3","4","3","10","","","","","","","20","20","40","40","0","","","14th","E8","POOR","NWACHUKWU MERCY","FAIR, TRY HARDER NEXT TIME","0","100","5","5","5","5","5","5","5","5","5","5","submit","2021/2022","2nd Term"),
("993","9","1","0","JSS 1","","LITERATURE-IN-ENGLISH","3","6","6","8","10","","","","","","","30","40","70","70","0","","","3rd","B2","VERY GOOD","NWACHUKWU MERCY","VERY GOOD, WELL DONE","0","100","5","5","5","5","5","5","5","5","5","5","submit","2021/2022","2nd Term"),
("994","10","1","0","JSS 1","","LITERATURE-IN-ENGLISH","3","5","8","5","0","","","","","","","18","38","56","56","0","","","10th","C5","CREDIT","NWACHUKWU MERCY","GOOD WORK. WORK HARDER","0","100","5","5","5","5","5","5","5","5","5","5","submit","2021/2022","2nd Term"),
("995","11","1","0","JSS 1","","LITERATURE-IN-ENGLISH","3","8","5","7","10","","","","","","","30","40","70","70","0","","","3rd","B2","VERY GOOD","NWACHUKWU MERCY","VERY GOOD, WELL DONE","0","100","5","5","5","5","5","5","5","5","5","5","submit","2021/2022","2nd Term"),
("996","13","1","0","JSS 1","","LITERATURE-IN-ENGLISH","3","5","5","5","10","","","","","","","25","30","55","55","0","","","11th","C5","CREDIT","NWACHUKWU MERCY","GOOD WORK. WORK HARDER","0","100","5","5","5","5","5","5","5","5","5","5","submit","2021/2022","2nd Term"),
("997","5","1","0","JSS 1","","LITERATURE-IN-ENGLISH","3","5","5","5","10","","","","","","","25","35","60","60","0","","","8th","C4","CREDIT","NWACHUKWU MERCY","SATISFACTORY. YOU CAN DO BETTER.","0","100","5","5","5","5","5","5","5","5","5","5","submit","2021/2022","2nd Term"),
("998","14","1","0","JSS 1","","LITERATURE-IN-ENGLISH","3","6","5","6","10","","","","","","","27","50","77","77","0","","","2nd","B2","VERY GOOD","NWACHUKWU MERCY","VERY GOOD, WELL DONE","0","100","5","5","5","5","5","5","5","5","5","5","submit","2021/2022","2nd Term"),
("999","15","2","0","JSS 2","","CULTURAL AND CREATIVE ARTS","2","9","2","5","10","","","","","","","26","35","61","61","0","","","9th","C4","CREDIT","NWACHUKWU MERCY","SATISFACTORY. YOU CAN DO BETTER.","0","100","5","5","5","5","5","5","5","5","5","5","submit","2021/2022","2nd Term"),
("1000","16","2","0","JSS 2","","CULTURAL AND CREATIVE ARTS","2","9","10","5","10","","","","","","","34","45","79","79","0","","","2nd","B2","VERY GOOD","NWACHUKWU MERCY","VERY GOOD, WELL DONE","0","100","5","5","5","5","5","5","5","5","5","5","submit","2021/2022","2nd Term"),
("1001","17","2","0","JSS 2","","CULTURAL AND CREATIVE ARTS","2","10","10","6","10","","","","","","","36","34","70","70","0","","","8th","B2","VERY GOOD","NWACHUKWU MERCY","VERY GOOD, WELL DONE","0","100","5","5","5","5","5","5","5","5","5","5","submit","2021/2022","2nd Term"),
("1002","18","2","0","JSS 2","","CULTURAL AND CREATIVE ARTS","2","10","10","6","10","","","","","","","36","47","83","83","0","","","1st","A1","EXCELLENT","NWACHUKWU MERCY","EXCELLENT PERFORMANCE, KEEP IT UP","0","100","5","5","5","5","5","5","5","5","5","5","submit","2021/2022","2nd Term"),
("1003","19","2","0","JSS 2","","CULTURAL AND CREATIVE ARTS","2","10","10","5","10","","","","","","","35","38","73","73","0","","","5th","B2","VERY GOOD","NWACHUKWU MERCY","VERY GOOD, WELL DONE","0","100","5","5","5","5","5","5","5","5","5","5","submit","2021/2022","2nd Term"),
("1004","20","2","0","JSS 2","","CULTURAL AND CREATIVE ARTS","2","9","10","4","10","","","","","","","33","38","71","71","0","","","7th","B2","VERY GOOD","NWACHUKWU MERCY","VERY GOOD, WELL DONE","0","100","5","5","5","5","5","5","5","5","5","5","submit","2021/2022","2nd Term"),
("1005","21","2","0","JSS 2","","CULTURAL AND CREATIVE ARTS","2","9","10","4","10","","","","","","","33","40","73","73","0","","","5th","B2","VERY GOOD","NWACHUKWU MERCY","VERY GOOD, WELL DONE","0","100","5","5","5","5","5","5","5","5","5","5","submit","2021/2022","2nd Term"),
("1006","22","2","0","JSS 2","","CULTURAL AND CREATIVE ARTS","2","9","2","6","10","","","","","","","27","32","59","59","0","","","10th","C5","CREDIT","NWACHUKWU MERCY","GOOD WORK. WORK HARDER","0","100","5","5","5","5","5","5","5","5","5","5","submit","2021/2022","2nd Term"),
("1007","23","2","0","JSS 2","","CULTURAL AND CREATIVE ARTS","2","9","10","5","10","","","","","","","34","44","78","78","0","","","3rd","B2","VERY GOOD","NWACHUKWU MERCY","VERY GOOD, WELL DONE","0","100","5","5","5","5","5","5","5","5","5","5","submit","2021/2022","2nd Term"),
("1008","34","2","0","JSS 2","","CULTURAL AND CREATIVE ARTS","2","10","10","5","10","","","","","","","35","39","74","74","0","","","4th","B2","VERY GOOD","NWACHUKWU MERCY","VERY GOOD, WELL DONE","0","100","5","5","5","5","5","5","5","5","5","5","submit","2021/2022","2nd Term"),
("1009","15","2","0","JSS 2","","ENGLISH LANGUAGE","1","5","7","9","10","","","","","","","31","43","74","74","0","","","5th","B2","VERY GOOD","NWACHUKWU MERCY","VERY GOOD, WELL DONE","0","100","5","5","5","5","5","5","5","5","5","5","submit","2021/2022","2nd Term"),
("1010","16","2","0","JSS 2","","ENGLISH LANGUAGE","1","5","6","9","10","","","","","","","30","48","78","78","0","","","3rd","B2","VERY GOOD","NWACHUKWU MERCY","VERY GOOD, WELL DONE","0","100","5","5","5","5","5","5","5","5","5","5","submit","2021/2022","2nd Term"),
("1011","17","2","0","JSS 2","","ENGLISH LANGUAGE","1","6","6","8","10","","","","","","","30","40","70","70","0","","","7th","B2","VERY GOOD","NWACHUKWU MERCY","VERY GOOD, WELL DONE","0","100","5","5","5","5","5","5","5","5","5","5","submit","2021/2022","2nd Term"),
("1012","18","2","0","JSS 2","","ENGLISH LANGUAGE","1","10","10","10","10","","","","","","","40","54","94","94","0","","","1st","A1","DISTINCTION","NWACHUKWU MERCY","EXCEPTIONAL WORK. WONDERFULLY DONE.","0","100","5","5","5","5","5","5","5","5","5","5","submit","2021/2022","2nd Term"),
("1013","19","2","0","JSS 2","","ENGLISH LANGUAGE","1","7","5","7","10","","","","","","","29","46","75","75","0","","","4th","B2","VERY GOOD","NWACHUKWU MERCY","VERY GOOD, WELL DONE","0","100","5","5","5","5","5","5","5","5","5","5","submit","2021/2022","2nd Term"),
("1014","20","2","0","JSS 2","","ENGLISH LANGUAGE","1","7","6","6","10","","","","","","","29","50","79","79","0","","","2nd","B2","VERY GOOD","NWACHUKWU MERCY","VERY GOOD, WELL DONE","0","100","5","5","5","5","5","5","5","5","5","5","submit","2021/2022","2nd Term"),
("1015","21","2","0","JSS 2","","ENGLISH LANGUAGE","1","4","6","5","10","","","","","","","25","38","63","63","0","","","8th","C4","CREDIT","NWACHUKWU MERCY","SATISFACTORY. YOU CAN DO BETTER.","0","100","5","5","5","5","5","5","5","5","5","5","submit","2021/2022","2nd Term"),
("1016","22","2","0","JSS 2","","ENGLISH LANGUAGE","1","5","5","5","10","","","","","","","25","33","58","58","0","","","10th","C5","CREDIT","NWACHUKWU MERCY","GOOD WORK. WORK HARDER","0","100","5","5","5","5","5","5","5","5","5","5","submit","2021/2022","2nd Term"),
("1017","23","2","0","JSS 2","","ENGLISH LANGUAGE","1","7","8","8","10","","","","","","","33","40","73","73","0","","","6th","B2","VERY GOOD","NWACHUKWU MERCY","VERY GOOD, WELL DONE","0","100","5","5","5","5","5","5","5","5","5","5","submit","2021/2022","2nd Term"),
("1018","34","2","0","JSS 2","","ENGLISH LANGUAGE","1","7","5","6","10","","","","","","","28","35","63","63","0","","","8th","C4","CREDIT","NWACHUKWU MERCY","SATISFACTORY. YOU CAN DO BETTER.","0","100","5","5","5","5","5","5","5","5","5","5","submit","2021/2022","2nd Term"),
("1019","15","2","0","JSS 2","","LITERATURE-IN-ENGLISH","3","3","2","4","10","","","","","","","19","20","39","39","0","","","6th","F9","FAIL","NWACHUKWU MERCY","FAIR, YOU CAN DO BETTER","0","100","5","5","5","5","5","5","5","5","5","5","submit","2021/2022","2nd Term"),
("1020","16","2","0","JSS 2","","LITERATURE-IN-ENGLISH","3","3","3","3","10","","","","","","","19","20","39","39","0","","","6th","F9","FAIL","NWACHUKWU MERCY","FAIR, YOU CAN DO BETTER","0","100","5","5","5","5","5","5","5","5","5","5","submit","2021/2022","2nd Term"),
("1021","17","2","0","JSS 2","","LITERATURE-IN-ENGLISH","3","6","6","5","10","","","","","","","27","35","62","62","0","","","3rd","C4","CREDIT","NWACHUKWU MERCY","SATISFACTORY. YOU CAN DO BETTER.","0","100","5","5","5","5","5","5","5","5","5","5","submit","2021/2022","2nd Term"),
("1022","18","2","0","JSS 2","","LITERATURE-IN-ENGLISH","3","10","9","10","10","","","","","","","39","56","95","95","0","","","1st","A1","DISTINCTION","NWACHUKWU MERCY","EXCEPTIONAL WORK. WONDERFULLY DONE.","0","100","5","5","5","5","5","5","5","5","5","5","submit","2021/2022","2nd Term"),
("1023","19","2","0","JSS 2","","LITERATURE-IN-ENGLISH","3","6","4","6","10","","","","","","","26","35","61","61","0","","","4th","C4","CREDIT","NWACHUKWU MERCY","SATISFACTORY. YOU CAN DO BETTER.","0","100","5","5","5","5","5","5","5","5","5","5","submit","2021/2022","2nd Term"),
("1024","20","2","0","JSS 2","","LITERATURE-IN-ENGLISH","3","9","8","9","10","","","","","","","36","48","84","84","0","","","2nd","A1","EXCELLENT","NWACHUKWU MERCY","EXCELLENT PERFORMANCE, KEEP IT UP","0","100","5","5","5","5","5","5","5","5","5","5","submit","2021/2022","2nd Term"),
("1025","21","2","0","JSS 2","","LITERATURE-IN-ENGLISH","3","3","3","3","10","","","","","","","19","20","39","39","0","","","6th","F9","FAIL","NWACHUKWU MERCY","FAIR, YOU CAN DO BETTER","0","100","5","5","5","5","5","5","5","5","5","5","submit","2021/2022","2nd Term"),
("1026","22","2","0","JSS 2","","LITERATURE-IN-ENGLISH","3","3","2","3","10","","","","","","","18","20","38","38","0","","","10th","F9","FAIL","NWACHUKWU MERCY","FAIR, YOU CAN DO BETTER","0","100","5","5","5","5","5","5","5","5","5","5","submit","2021/2022","2nd Term"),
("1027","23","2","0","JSS 2","","LITERATURE-IN-ENGLISH","3","3","4","2","10","","","","","","","19","20","39","39","0","","","6th","F9","FAIL","NWACHUKWU MERCY","FAIR, YOU CAN DO BETTER","0","100","5","5","5","5","5","5","5","5","5","5","submit","2021/2022","2nd Term");
INSERT INTO result_subject VALUES
("1028","34","2","0","JSS 2","","LITERATURE-IN-ENGLISH","3","4","5","3","10","","","","","","","22","30","52","52","0","","","5th","C6","CREDIT","NWACHUKWU MERCY","GOOD WORK. WORK HARDER","0","100","5","5","5","5","5","5","5","5","5","5","submit","2021/2022","2nd Term"),
("1029","26","3","0","JSS 3","","CULTURAL AND CREATIVE ARTS","2","9","7","8","10","","","","","","","34","43","77","77","0","","","1st","B2","VERY GOOD","NWACHUKWU MERCY","VERY GOOD, WELL DONE","0","100","5","5","5","5","5","5","5","5","5","5","submit","2021/2022","2nd Term"),
("1030","27","3","0","JSS 3","","CULTURAL AND CREATIVE ARTS","2","9","3","4","10","","","","","","","26","25","51","51","0","","","7th","C6","CREDIT","NWACHUKWU MERCY","GOOD WORK. WORK HARDER","0","100","5","5","5","5","5","5","5","5","5","5","submit","2021/2022","2nd Term"),
("1031","29","3","0","JSS 3","","CULTURAL AND CREATIVE ARTS","2","8","5","5","10","","","","","","","28","40","68","68","0","","","3rd","B3","GOOD","NWACHUKWU MERCY","SATISFACTORY. YOU CAN DO BETTER.","0","100","5","5","5","5","5","5","5","5","5","5","submit","2021/2022","2nd Term"),
("1032","30","3","0","JSS 3","","CULTURAL AND CREATIVE ARTS","2","4","3","3","10","","","","","","","20","20","40","40","0","","","8th","E8","POOR","NWACHUKWU MERCY","FAIR, TRY HARDER NEXT TIME","0","100","5","5","5","5","5","5","5","5","5","5","submit","2021/2022","2nd Term"),
("1033","33","3","0","JSS 3","","CULTURAL AND CREATIVE ARTS","2","8","2","7","8","","","","","","","25","41","66","66","0","","","4th","B3","GOOD","NWACHUKWU MERCY","SATISFACTORY. YOU CAN DO BETTER.","0","100","5","5","5","5","5","5","5","5","5","5","submit","2021/2022","2nd Term"),
("1034","31","3","0","JSS 3","","CULTURAL AND CREATIVE ARTS","2","9","2","5","8","","","","","","","24","38","62","62","0","","","6th","C4","CREDIT","NWACHUKWU MERCY","SATISFACTORY. YOU CAN DO BETTER.","0","100","5","5","5","5","5","5","5","5","5","5","submit","2021/2022","2nd Term"),
("1035","28","3","0","JSS 3","","CULTURAL AND CREATIVE ARTS","2","9","5","2","10","","","","","","","26","40","66","66","0","","","4th","B3","GOOD","NWACHUKWU MERCY","SATISFACTORY. YOU CAN DO BETTER.","0","100","5","5","5","5","5","5","5","5","5","5","submit","2021/2022","2nd Term"),
("1036","32","3","0","JSS 3","","CULTURAL AND CREATIVE ARTS","2","10","5","8","10","","","","","","","33","41","74","74","0","","","2nd","B2","VERY GOOD","NWACHUKWU MERCY","VERY GOOD, WELL DONE","0","100","5","5","5","5","5","5","5","5","5","5","submit","2021/2022","2nd Term"),
("1037","26","3","0","JSS 3","","ENGLISH LANGUAGE","1","10","5","8","10","","","","","","","33","38","71","71","0","","","2nd","B2","VERY GOOD","NWACHUKWU MERCY","VERY GOOD, WELL DONE","0","100","5","5","5","5","5","5","5","5","5","5","submit","2021/2022","2nd Term"),
("1038","27","3","0","JSS 3","","ENGLISH LANGUAGE","1","8","5","4","10","","","","","","","27","15","42","42","0","","","7th","E8","POOR","NWACHUKWU MERCY","FAIR, TRY HARDER NEXT TIME","0","100","5","5","5","5","5","5","5","5","5","5","submit","2021/2022","2nd Term"),
("1039","29","3","0","JSS 3","","ENGLISH LANGUAGE","1","6","5","6","10","","","","","","","27","35","62","62","0","","","4th","C4","CREDIT","NWACHUKWU MERCY","SATISFACTORY. YOU CAN DO BETTER.","0","100","5","5","5","5","5","5","5","5","5","5","submit","2021/2022","2nd Term"),
("1040","30","3","0","JSS 3","","ENGLISH LANGUAGE","1","4","3","3","10","","","","","","","20","15","35","35","0","","","8th","F9","FAIL","NWACHUKWU MERCY","FAIR, YOU CAN DO BETTER","0","100","5","5","5","5","5","5","5","5","5","5","submit","2021/2022","2nd Term"),
("1041","33","3","0","JSS 3","","ENGLISH LANGUAGE","1","5","4","4","10","","","","","","","23","25","48","48","0","","","6th","D7","PASS","NWACHUKWU MERCY","FAIR, TRY HARDER NEXT TIME","0","100","5","5","5","5","5","5","5","5","5","5","submit","2021/2022","2nd Term"),
("1042","31","3","0","JSS 3","","ENGLISH LANGUAGE","1","6","5","6","10","","","","","","","27","27","54","54","0","","","5th","C6","CREDIT","NWACHUKWU MERCY","GOOD WORK. WORK HARDER","0","100","5","5","5","5","5","5","5","5","5","5","submit","2021/2022","2nd Term"),
("1043","28","3","0","JSS 3","","ENGLISH LANGUAGE","1","9","5","2","10","","","","","","","26","40","66","66","0","","","3rd","B3","GOOD","NWACHUKWU MERCY","SATISFACTORY. YOU CAN DO BETTER.","0","100","5","5","5","5","5","5","5","5","5","5","submit","2021/2022","2nd Term"),
("1044","32","3","0","JSS 3","","ENGLISH LANGUAGE","1","9","6","6","10","","","","","","","31","41","72","72","0","","","1st","B2","VERY GOOD","NWACHUKWU MERCY","VERY GOOD, WELL DONE","0","100","5","5","5","5","5","5","5","5","5","5","submit","2021/2022","2nd Term"),
("1045","26","3","0","JSS 3","","LITERATURE-IN-ENGLISH","3","3","3","4","10","","","","","","","20","40","60","60","0","","","3rd","C4","CREDIT","NWACHUKWU MERCY","SATISFACTORY. YOU CAN DO BETTER.","0","100","5","5","5","5","5","5","5","5","5","5","submit","2021/2022","2nd Term"),
("1046","27","3","0","JSS 3","","LITERATURE-IN-ENGLISH","3","2","3","2","10","","","","","","","17","15","32","32","0","","","7th","F9","FAIL","NWACHUKWU MERCY","FAIR, YOU CAN DO BETTER","0","100","5","5","5","5","5","5","5","5","5","5","submit","2021/2022","2nd Term"),
("1047","29","3","0","JSS 3","","LITERATURE-IN-ENGLISH","3","3","3","2","10","","","","","","","18","30","48","48","0","","","5th","D7","PASS","NWACHUKWU MERCY","FAIR, TRY HARDER NEXT TIME","0","100","5","5","5","5","5","5","5","5","5","5","submit","2021/2022","2nd Term"),
("1048","30","3","0","JSS 3","","LITERATURE-IN-ENGLISH","3","2","2","2","10","","","","","","","16","15","31","31","0","","","8th","F9","FAIL","NWACHUKWU MERCY","FAIR, YOU CAN DO BETTER","0","100","5","5","5","5","5","5","5","5","5","5","submit","2021/2022","2nd Term"),
("1049","33","3","0","JSS 3","","LITERATURE-IN-ENGLISH","3","5","5","5","10","","","","","","","25","30","55","55","0","","","4th","C5","CREDIT","NWACHUKWU MERCY","GOOD WORK. WORK HARDER","0","100","5","5","5","5","5","5","5","5","5","5","submit","2021/2022","2nd Term"),
("1050","31","3","0","JSS 3","","LITERATURE-IN-ENGLISH","3","3","3","2","10","","","","","","","18","30","48","48","0","","","5th","D7","PASS","NWACHUKWU MERCY","FAIR, TRY HARDER NEXT TIME","0","100","5","5","5","5","5","5","5","5","5","5","submit","2021/2022","2nd Term"),
("1051","28","3","0","JSS 3","","LITERATURE-IN-ENGLISH","3","6","5","3","10","","","","","","","24","42","66","66","0","","","1st","B3","GOOD","NWACHUKWU MERCY","SATISFACTORY. YOU CAN DO BETTER.","0","100","5","5","5","5","5","5","5","5","5","5","submit","2021/2022","2nd Term"),
("1052","32","3","0","JSS 3","","LITERATURE-IN-ENGLISH","3","4","4","4","10","","","","","","","22","40","62","62","0","","","2nd","C4","CREDIT","NWACHUKWU MERCY","SATISFACTORY. YOU CAN DO BETTER.","0","100","5","5","5","5","5","5","5","5","5","5","submit","2021/2022","2nd Term"),
("1053","2","1","0","JSS 1","","BUSINESS STUDIES","14","10","10","10","10","","","","","","","40","45","85","85","0","","","3rd","A1","EXCELLENT","ZEON GLOBAL","EXCELLENT PERFORMANCE, KEEP IT UP","0","100","5","5","5","5","5","5","5","5","5","5","submit","2021/2022","2nd Term"),
("1054","35","1","0","JSS 1","","BUSINESS STUDIES","14","10","10","10","5","","","","","","","35","34","69","69","0","","","6th","B3","GOOD","ZEON GLOBAL","SATISFACTORY. YOU CAN DO BETTER.","0","100","5","5","5","5","5","5","5","5","5","5","submit","2021/2022","2nd Term"),
("1055","1","1","0","JSS 1","","BUSINESS STUDIES","14","10","10","10","5","","","","","","","35","33","68","68","0","","","7th","B3","GOOD","ZEON GLOBAL","SATISFACTORY. YOU CAN DO BETTER.","0","100","5","5","5","5","5","5","5","5","5","5","submit","2021/2022","2nd Term"),
("1056","3","1","0","JSS 1","","BUSINESS STUDIES","14","10","10","10","5","","","","","","","35","25","60","60","0","","","9th","C4","CREDIT","ZEON GLOBAL","SATISFACTORY. YOU CAN DO BETTER.","0","100","5","5","5","5","5","5","5","5","5","5","submit","2021/2022","2nd Term"),
("1057","4","1","0","JSS 1","","BUSINESS STUDIES","14","10","10","10","5","","","","","","","35","51","86","86","0","","","1st","A1","EXCELLENT","ZEON GLOBAL","EXCELLENT PERFORMANCE, KEEP IT UP","0","100","5","5","5","5","5","5","5","5","5","5","submit","2021/2022","2nd Term"),
("1058","6","1","0","JSS 1","","BUSINESS STUDIES","14","10","10","3","5","","","","","","","28","16","44","44","0","","","13th","E8","POOR","ZEON GLOBAL","FAIR, TRY HARDER NEXT TIME","0","100","5","5","5","5","5","5","5","5","5","5","submit","2021/2022","2nd Term"),
("1059","7","1","0","JSS 1","","BUSINESS STUDIES","14","10","10","5","5","","","","","","","30","24","54","54","0","","","11th","C6","CREDIT","ZEON GLOBAL","GOOD WORK. WORK HARDER","0","100","5","5","5","5","5","5","5","5","5","5","submit","2021/2022","2nd Term"),
("1060","8","1","0","JSS 1","","BUSINESS STUDIES","14","10","10","5","5","","","","","","","30","22","52","52","0","","","12th","C6","CREDIT","ZEON GLOBAL","GOOD WORK. WORK HARDER","0","100","5","5","5","5","5","5","5","5","5","5","submit","2021/2022","2nd Term"),
("1061","9","1","0","JSS 1","","BUSINESS STUDIES","14","3","3","5","5","","","","","","","16","17","33","33","0","","","14th","F9","FAIL","ZEON GLOBAL","FAIR, YOU CAN DO BETTER","0","100","5","5","5","5","5","5","5","5","5","5","submit","2021/2022","2nd Term"),
("1062","10","1","0","JSS 1","","BUSINESS STUDIES","14","10","10","10","5","","","","","","","35","51","86","86","0","","","1st","A1","EXCELLENT","ZEON GLOBAL","EXCELLENT PERFORMANCE, KEEP IT UP","0","100","5","5","5","5","5","5","5","5","5","5","submit","2021/2022","2nd Term"),
("1063","11","1","0","JSS 1","","BUSINESS STUDIES","14","10","10","5","5","","","","","","","30","30","60","60","0","","","9th","C4","CREDIT","ZEON GLOBAL","SATISFACTORY. YOU CAN DO BETTER.","0","100","5","5","5","5","5","5","5","5","5","5","submit","2021/2022","2nd Term"),
("1064","13","1","0","JSS 1","","BUSINESS STUDIES","14","10","10","10","5","","","","","","","35","26","61","61","0","","","8th","C4","CREDIT","ZEON GLOBAL","SATISFACTORY. YOU CAN DO BETTER.","0","100","5","5","5","5","5","5","5","5","5","5","submit","2021/2022","2nd Term"),
("1065","5","1","0","JSS 1","","BUSINESS STUDIES","14","10","10","10","10","","","","","","","40","39","79","79","0","","","5th","B2","VERY GOOD","ZEON GLOBAL","VERY GOOD, WELL DONE","0","100","5","5","5","5","5","5","5","5","5","5","submit","2021/2022","2nd Term"),
("1066","14","1","0","JSS 1","","BUSINESS STUDIES","14","10","10","10","5","","","","","","","35","47","82","82","0","","","4th","A1","EXCELLENT","ZEON GLOBAL","EXCELLENT PERFORMANCE, KEEP IT UP","0","100","5","5","5","5","5","5","5","5","5","5","submit","2021/2022","2nd Term"),
("1067","15","2","0","JSS 2","","BUSINESS STUDIES","14","3","3","3","10","","","","","","","19","31","50","50","0","","","8th","C6","CREDIT","ZEON GLOBAL","GOOD WORK. WORK HARDER","0","100","5","5","5","5","5","5","5","5","5","5","submit","2021/2022","2nd Term"),
("1068","16","2","0","JSS 2","","BUSINESS STUDIES","14","10","10","5","10","","","","","","","35","35","70","70","0","","","5th","B2","VERY GOOD","ZEON GLOBAL","VERY GOOD, WELL DONE","0","100","5","5","5","5","5","5","5","5","5","5","submit","2021/2022","2nd Term"),
("1069","17","2","0","JSS 2","","BUSINESS STUDIES","14","3","3","3","10","","","","","","","19","25","44","44","0","","","10th","E8","POOR","ZEON GLOBAL","FAIR, TRY HARDER NEXT TIME","0","100","5","5","5","5","5","5","5","5","5","5","submit","2021/2022","2nd Term"),
("1070","18","2","0","JSS 2","","BUSINESS STUDIES","14","10","10","10","10","","","","","","","40","45","85","85","0","","","1st","A1","EXCELLENT","ZEON GLOBAL","EXCELLENT PERFORMANCE, KEEP IT UP","0","100","5","5","5","5","5","5","5","5","5","5","submit","2021/2022","2nd Term"),
("1071","19","2","0","JSS 2","","BUSINESS STUDIES","14","10","10","3","10","","","","","","","33","42","75","75","0","","","3rd","B2","VERY GOOD","ZEON GLOBAL","VERY GOOD, WELL DONE","0","100","5","5","5","5","5","5","5","5","5","5","submit","2021/2022","2nd Term"),
("1072","20","2","0","JSS 2","","BUSINESS STUDIES","14","10","10","10","10","","","","","","","40","42","82","82","0","","","2nd","A1","EXCELLENT","ZEON GLOBAL","EXCELLENT PERFORMANCE, KEEP IT UP","0","100","5","5","5","5","5","5","5","5","5","5","submit","2021/2022","2nd Term"),
("1073","21","2","0","JSS 2","","BUSINESS STUDIES","14","3","3","3","10","","","","","","","19","33","52","52","0","","","7th","C6","CREDIT","ZEON GLOBAL","GOOD WORK. WORK HARDER","0","100","5","5","5","5","5","5","5","5","5","5","submit","2021/2022","2nd Term"),
("1074","22","2","0","JSS 2","","BUSINESS STUDIES","14","3","3","3","10","","","","","","","19","26","45","45","0","","","9th","D7","PASS","ZEON GLOBAL","FAIR, TRY HARDER NEXT TIME","0","100","5","5","5","5","5","5","5","5","5","5","submit","2021/2022","2nd Term"),
("1075","23","2","0","JSS 2","","BUSINESS STUDIES","14","10","10","10","10","","","","","","","40","29","69","69","0","","","6th","B3","GOOD","ZEON GLOBAL","SATISFACTORY. YOU CAN DO BETTER.","0","100","5","5","5","5","5","5","5","5","5","5","submit","2021/2022","2nd Term"),
("1076","34","2","0","JSS 2","","BUSINESS STUDIES","14","10","8","8","10","","","","","","","36","35","71","71","0","","","4th","B2","VERY GOOD","ZEON GLOBAL","VERY GOOD, WELL DONE","0","100","5","5","5","5","5","5","5","5","5","5","submit","2021/2022","2nd Term"),
("1077","26","3","0","JSS 3","","BUSINESS STUDIES","14","10","10","10","10","","","","","","","40","48","88","88","0","","","1st","A1","EXCELLENT","ZEON GLOBAL","EXCELLENT PERFORMANCE, KEEP IT UP","0","100","5","5","5","5","5","5","5","5","5","5","submit","2021/2022","2nd Term"),
("1078","27","3","0","JSS 3","","BUSINESS STUDIES","14","3","3","3","10","","","","","","","19","30","49","49","0","","","6th","D7","PASS","ZEON GLOBAL","FAIR, TRY HARDER NEXT TIME","0","100","5","5","5","5","5","5","5","5","5","5","submit","2021/2022","2nd Term"),
("1079","29","3","0","JSS 3","","BUSINESS STUDIES","14","3","3","3","10","","","","","","","19","37","56","56","0","","","5th","C5","CREDIT","ZEON GLOBAL","GOOD WORK. WORK HARDER","0","100","5","5","5","5","5","5","5","5","5","5","submit","2021/2022","2nd Term"),
("1080","30","3","0","JSS 3","","BUSINESS STUDIES","14","3","3","3","10","","","","","","","19","10","29","29","0","","","8th","F9","FAIL","ZEON GLOBAL","FAIR, YOU CAN DO BETTER","0","100","5","5","5","5","5","5","5","5","5","5","submit","2021/2022","2nd Term"),
("1081","33","3","0","JSS 3","","BUSINESS STUDIES","14","3","3","3","10","","","","","","","19","24","43","43","0","","","7th","E8","POOR","ZEON GLOBAL","FAIR, TRY HARDER NEXT TIME","0","100","5","5","5","5","5","5","5","5","5","5","submit","2021/2022","2nd Term"),
("1082","31","3","0","JSS 3","","BUSINESS STUDIES","14","10","10","3","10","","","","","","","33","34","67","67","0","","","4th","B3","GOOD","ZEON GLOBAL","SATISFACTORY. YOU CAN DO BETTER.","0","100","5","5","5","5","5","5","5","5","5","5","submit","2021/2022","2nd Term"),
("1083","28","3","0","JSS 3","","BUSINESS STUDIES","14","10","10","5","10","","","","","","","35","44","79","79","0","","","2nd","B2","VERY GOOD","ZEON GLOBAL","VERY GOOD, WELL DONE","0","100","5","5","5","5","5","5","5","5","5","5","submit","2021/2022","2nd Term"),
("1084","32","3","0","JSS 3","","BUSINESS STUDIES","14","10","8","8","10","","","","","","","36","43","79","79","0","","","2nd","B2","VERY GOOD","ZEON GLOBAL","VERY GOOD, WELL DONE","0","100","5","5","5","5","5","5","5","5","5","5","submit","2021/2022","2nd Term"),
("1085","26","3","0","JSS 3","","SECURITY EDUCATION","11","10","10","8","10","","","","","","","38","50","88","88","0","","","3rd","A1","EXCELLENT","MRS OKPEAJI","EXCELLENT PERFORMANCE, KEEP IT UP","0","100","5","5","5","5","5","5","5","5","5","5","submit","2021/2022","2nd Term"),
("1086","27","3","0","JSS 3","","SECURITY EDUCATION","11","10","10","8","10","","","","","","","38","39","77","77","0","","","5th","B2","VERY GOOD","MRS OKPEAJI","VERY GOOD, WELL DONE","0","100","5","5","5","5","5","5","5","5","5","5","submit","2021/2022","2nd Term"),
("1087","29","3","0","JSS 3","","SECURITY EDUCATION","11","10","10","7","10","","","","","","","37","42","79","79","0","","","4th","B2","VERY GOOD","MRS OKPEAJI","VERY GOOD, WELL DONE","0","100","5","5","5","5","5","5","5","5","5","5","submit","2021/2022","2nd Term"),
("1088","30","3","0","JSS 3","","SECURITY EDUCATION","11","2","2","2","10","","","","","","","16","15","31","31","0","","","8th","F9","FAIL","MRS OKPEAJI","FAIR, YOU CAN DO BETTER","0","100","5","5","5","5","5","5","5","5","5","5","submit","2021/2022","2nd Term"),
("1089","33","3","0","JSS 3","","SECURITY EDUCATION","11","9","9","8","10","","","","","","","36","33","69","69","0","","","7th","B3","GOOD","MRS OKPEAJI","SATISFACTORY. YOU CAN DO BETTER.","0","100","5","5","5","5","5","5","5","5","5","5","submit","2021/2022","2nd Term"),
("1090","31","3","0","JSS 3","","SECURITY EDUCATION","11","7","7","9","10","","","","","","","33","37","70","70","0","","","6th","B2","VERY GOOD","MRS OKPEAJI","VERY GOOD, WELL DONE","0","100","5","5","5","5","5","5","5","5","5","5","submit","2021/2022","2nd Term"),
("1091","28","3","0","JSS 3","","SECURITY EDUCATION","11","10","10","9","10","","","","","","","39","51","90","90","0","","","2nd","A1","DISTINCTION","MRS OKPEAJI","EXCEPTIONAL WORK. WONDERFULLY DONE.","0","100","5","5","5","5","5","5","5","5","5","5","submit","2021/2022","2nd Term"),
("1092","32","3","0","JSS 3","","SECURITY EDUCATION","11","10","10","9","10","","","","","","","39","55","94","94","0","","","1st","A1","DISTINCTION","MRS OKPEAJI","EXCEPTIONAL WORK. WONDERFULLY DONE.","0","100","5","5","5","5","5","5","5","5","5","5","submit","2021/2022","2nd Term"),
("1093","26","3","0","JSS 3","","SOCIAL STUDIES","12","10","10","10","10","","","","","","","40","48","88","88","0","","","3rd","A1","EXCELLENT","MRS OKPEAJI","EXCELLENT PERFORMANCE, KEEP IT UP","0","100","5","5","5","5","5","5","5","5","5","5","submit","2021/2022","2nd Term"),
("1094","27","3","0","JSS 3","","SOCIAL STUDIES","12","8","8","8","10","","","","","","","34","21","55","55","0","","","7th","C5","CREDIT","MRS OKPEAJI","GOOD WORK. WORK HARDER","0","100","5","5","5","5","5","5","5","5","5","5","submit","2021/2022","2nd Term"),
("1095","29","3","0","JSS 3","","SOCIAL STUDIES","12","10","10","10","10","","","","","","","40","32","72","72","0","","","5th","B2","VERY GOOD","MRS OKPEAJI","VERY GOOD, WELL DONE","0","100","5","5","5","5","5","5","5","5","5","5","submit","2021/2022","2nd Term"),
("1096","30","3","0","JSS 3","","SOCIAL STUDIES","12","8","8","8","10","","","","","","","34","11","45","45","0","","","8th","D7","PASS","MRS OKPEAJI","FAIR, TRY HARDER NEXT TIME","0","100","5","5","5","5","5","5","5","5","5","5","submit","2021/2022","2nd Term"),
("1097","33","3","0","JSS 3","","SOCIAL STUDIES","12","8","8","8","10","","","","","","","34","35","69","69","0","","","6th","B3","GOOD","MRS OKPEAJI","SATISFACTORY. YOU CAN DO BETTER.","0","100","5","5","5","5","5","5","5","5","5","5","submit","2021/2022","2nd Term"),
("1098","31","3","0","JSS 3","","SOCIAL STUDIES","12","8","8","8","8","","","","","","","32","43","75","75","0","","","4th","B2","VERY GOOD","MRS OKPEAJI","VERY GOOD, WELL DONE","0","100","5","5","5","5","5","5","5","5","5","5","submit","2021/2022","2nd Term"),
("1099","28","3","0","JSS 3","","SOCIAL STUDIES","12","10","10","10","10","","","","","","","40","50","90","90","0","","","1st","A1","DISTINCTION","MRS OKPEAJI","EXCEPTIONAL WORK. WONDERFULLY DONE.","0","100","5","5","5","5","5","5","5","5","5","5","submit","2021/2022","2nd Term"),
("1100","32","3","0","JSS 3","","SOCIAL STUDIES","12","10","10","10","10","","","","","","","40","49","89","89","0","","","2nd","A1","EXCELLENT","MRS OKPEAJI","EXCELLENT PERFORMANCE, KEEP IT UP","0","100","5","5","5","5","5","5","5","5","5","5","submit","2021/2022","2nd Term"),
("1101","2","1","0","JSS 1","","FRENCH LANGUAGE","15","10","10","8","8","","","","","","","36","48","84","84","0","","","1st","A1","EXCELLENT","MR MUYIWA","EXCELLENT PERFORMANCE, KEEP IT UP","0","100","5","5","5","5","5","5","5","5","5","5","submit","2021/2022","2nd Term"),
("1102","35","1","0","JSS 1","","FRENCH LANGUAGE","15","10","10","10","10","","","","","","","40","39","79","79","0","","","2nd","B2","VERY GOOD","MR MUYIWA","VERY GOOD, WELL DONE","0","100","5","5","5","5","5","5","5","5","5","5","submit","2021/2022","2nd Term"),
("1103","1","1","0","JSS 1","","FRENCH LANGUAGE","15","10","10","7","7","","","","","","","34","24","58","58","0","","","9th","C5","CREDIT","MR MUYIWA","GOOD WORK. WORK HARDER","0","100","5","5","5","5","5","5","5","5","5","5","submit","2021/2022","2nd Term"),
("1104","3","1","0","JSS 1","","FRENCH LANGUAGE","15","10","10","6","6","","","","","","","32","20","52","52","0","","","10th","C6","CREDIT","MR MUYIWA","GOOD WORK. WORK HARDER","0","100","5","5","5","5","5","5","5","5","5","5","submit","2021/2022","2nd Term"),
("1105","4","1","0","JSS 1","","FRENCH LANGUAGE","15","10","10","10","10","","","","","","","40","32","72","72","0","","","3rd","B2","VERY GOOD","MR MUYIWA","VERY GOOD, WELL DONE","0","100","5","5","5","5","5","5","5","5","5","5","submit","2021/2022","2nd Term"),
("1106","6","1","0","JSS 1","","FRENCH LANGUAGE","15","10","10","4","4","","","","","","","28","20","48","48","0","","","13th","D7","PASS","MR MUYIWA","FAIR, TRY HARDER NEXT TIME","0","100","5","5","5","5","5","5","5","5","5","5","submit","2021/2022","2nd Term"),
("1107","7","1","0","JSS 1","","FRENCH LANGUAGE","15","10","10","6","6","","","","","","","32","33","65","65","0","","","7th","B3","GOOD","MR MUYIWA","SATISFACTORY. YOU CAN DO BETTER.","0","100","5","5","5","5","5","5","5","5","5","5","submit","2021/2022","2nd Term"),
("1108","8","1","0","JSS 1","","FRENCH LANGUAGE","15","10","10","8","8","","","","","","","36","7","43","43","0","","","14th","E8","POOR","MR MUYIWA","FAIR, TRY HARDER NEXT TIME","0","100","5","5","5","5","5","5","5","5","5","5","submit","2021/2022","2nd Term"),
("1109","9","1","0","JSS 1","","FRENCH LANGUAGE","15","10","10","4","4","","","","","","","28","22","50","50","0","","","11th","C6","CREDIT","MR MUYIWA","GOOD WORK. WORK HARDER","0","100","5","5","5","5","5","5","5","5","5","5","submit","2021/2022","2nd Term"),
("1110","10","1","0","JSS 1","","FRENCH LANGUAGE","15","10","10","10","10","","","","","","","40","30","70","70","0","","","4th","B2","VERY GOOD","MR MUYIWA","VERY GOOD, WELL DONE","0","100","5","5","5","5","5","5","5","5","5","5","submit","2021/2022","2nd Term"),
("1111","11","1","0","JSS 1","","FRENCH LANGUAGE","15","10","10","8","8","","","","","","","36","33","69","69","0","","","5th","B3","GOOD","MR MUYIWA","SATISFACTORY. YOU CAN DO BETTER.","0","100","5","5","5","5","5","5","5","5","5","5","submit","2021/2022","2nd Term"),
("1112","13","1","0","JSS 1","","FRENCH LANGUAGE","15","10","10","5","5","","","","","","","30","20","50","50","0","","","11th","C6","CREDIT","MR MUYIWA","GOOD WORK. WORK HARDER","0","100","5","5","5","5","5","5","5","5","5","5","submit","2021/2022","2nd Term"),
("1113","5","1","0","JSS 1","","FRENCH LANGUAGE","15","10","10","6","6","","","","","","","32","32","64","64","0","","","8th","C4","CREDIT","MR MUYIWA","SATISFACTORY. YOU CAN DO BETTER.","0","100","5","5","5","5","5","5","5","5","5","5","submit","2021/2022","2nd Term"),
("1114","14","1","0","JSS 1","","FRENCH LANGUAGE","15","10","10","6","6","","","","","","","32","34","66","66","0","","","6th","B3","GOOD","MR MUYIWA","SATISFACTORY. YOU CAN DO BETTER.","0","100","5","5","5","5","5","5","5","5","5","5","submit","2021/2022","2nd Term"),
("1115","15","2","0","JSS 2","","FRENCH LANGUAGE","15","10","10","6","6","","","","","","","32","56","88","88","0","","","6th","A1","EXCELLENT","MR MUYIWA","EXCELLENT PERFORMANCE, KEEP IT UP","0","100","5","5","5","5","5","5","5","5","5","5","submit","2021/2022","2nd Term"),
("1116","16","2","0","JSS 2","","FRENCH LANGUAGE","15","10","10","6","6","","","","","","","32","59","91","91","0","","","3rd","A1","DISTINCTION","MR MUYIWA","EXCEPTIONAL WORK. WONDERFULLY DONE.","0","100","5","5","5","5","5","5","5","5","5","5","submit","2021/2022","2nd Term"),
("1117","17","2","0","JSS 2","","FRENCH LANGUAGE","15","10","10","6","6","","","","","","","32","54","86","86","0","","","7th","A1","EXCELLENT","MR MUYIWA","EXCELLENT PERFORMANCE, KEEP IT UP","0","100","5","5","5","5","5","5","5","5","5","5","submit","2021/2022","2nd Term"),
("1118","18","2","0","JSS 2","","FRENCH LANGUAGE","15","10","10","10","10","","","","","","","40","59","99","99","0","","","2nd","A1","DISTINCTION","MR MUYIWA","EXCEPTIONAL WORK. WONDERFULLY DONE.","0","100","5","5","5","5","5","5","5","5","5","5","submit","2021/2022","2nd Term"),
("1119","19","2","0","JSS 2","","FRENCH LANGUAGE","15","10","10","6","6","","","","","","","32","58","90","90","0","","","5th","A1","DISTINCTION","MR MUYIWA","EXCEPTIONAL WORK. WONDERFULLY DONE.","0","100","5","5","5","5","5","5","5","5","5","5","submit","2021/2022","2nd Term"),
("1120","20","2","0","JSS 2","","FRENCH LANGUAGE","15","10","10","6","6","","","","","","","32","59","91","91","0","","","3rd","A1","DISTINCTION","MR MUYIWA","EXCEPTIONAL WORK. WONDERFULLY DONE.","0","100","5","5","5","5","5","5","5","5","5","5","submit","2021/2022","2nd Term"),
("1121","21","2","0","JSS 2","","FRENCH LANGUAGE","15","10","10","4","4","","","","","","","28","58","86","86","0","","","7th","A1","EXCELLENT","MR MUYIWA","EXCELLENT PERFORMANCE, KEEP IT UP","0","100","5","5","5","5","5","5","5","5","5","5","submit","2021/2022","2nd Term"),
("1122","22","2","0","JSS 2","","FRENCH LANGUAGE","15","10","10","6","6","","","","","","","32","50","82","82","0","","","9th","A1","EXCELLENT","MR MUYIWA","EXCELLENT PERFORMANCE, KEEP IT UP","0","100","5","5","5","5","5","5","5","5","5","5","submit","2021/2022","2nd Term"),
("1123","23","2","0","JSS 2","","FRENCH LANGUAGE","15","10","10","10","10","","","","","","","40","60","100","100","0","","","1st","A1","DISTINCTION","MR MUYIWA","EXCEPTIONAL WORK. WONDERFULLY DONE.","0","100","5","5","5","5","5","5","5","5","5","5","submit","2021/2022","2nd Term"),
("1124","34","2","0","JSS 2","","FRENCH LANGUAGE","15","10","10","6","6","","","","","","","32","46","78","78","0","","","10th","B2","VERY GOOD","MR MUYIWA","VERY GOOD, WELL DONE","0","100","5","5","5","5","5","5","5","5","5","5","submit","2021/2022","2nd Term"),
("1125","26","3","0","JSS 3","","FRENCH LANGUAGE","15","10","10","9","9","","","","","","","38","56","94","94","0","","","1st","A1","DISTINCTION","MR MUYIWA","EXCEPTIONAL WORK. WONDERFULLY DONE.","0","100","5","5","5","5","5","5","5","5","5","5","submit","2021/2022","2nd Term"),
("1126","27","3","0","JSS 3","","FRENCH LANGUAGE","15","10","10","10","10","","","","","","","40","33","73","73","0","","","4th","B2","VERY GOOD","MR MUYIWA","VERY GOOD, WELL DONE","0","100","5","5","5","5","5","5","5","5","5","5","submit","2021/2022","2nd Term"),
("1127","29","3","0","JSS 3","","FRENCH LANGUAGE","15","10","10","9","9","","","","","","","38","45","83","83","0","","","2nd","A1","EXCELLENT","MR MUYIWA","EXCELLENT PERFORMANCE, KEEP IT UP","0","100","5","5","5","5","5","5","5","5","5","5","submit","2021/2022","2nd Term");
INSERT INTO result_subject VALUES
("1128","30","3","0","JSS 3","","FRENCH LANGUAGE","15","10","10","10","10","","","","","","","40","10","50","50","0","","","8th","C6","CREDIT","MR MUYIWA","GOOD WORK. WORK HARDER","0","100","5","5","5","5","5","5","5","5","5","5","submit","2021/2022","2nd Term"),
("1129","33","3","0","JSS 3","","FRENCH LANGUAGE","15","10","10","9","9","","","","","","","38","24","62","62","0","","","7th","C4","CREDIT","MR MUYIWA","SATISFACTORY. YOU CAN DO BETTER.","0","100","5","5","5","5","5","5","5","5","5","5","submit","2021/2022","2nd Term"),
("1130","31","3","0","JSS 3","","FRENCH LANGUAGE","15","10","10","9","9","","","","","","","38","30","68","68","0","","","6th","B3","GOOD","MR MUYIWA","SATISFACTORY. YOU CAN DO BETTER.","0","100","5","5","5","5","5","5","5","5","5","5","submit","2021/2022","2nd Term"),
("1131","28","3","0","JSS 3","","FRENCH LANGUAGE","15","10","10","9","9","","","","","","","38","43","81","81","0","","","3rd","A1","EXCELLENT","MR MUYIWA","EXCELLENT PERFORMANCE, KEEP IT UP","0","100","5","5","5","5","5","5","5","5","5","5","submit","2021/2022","2nd Term"),
("1132","32","3","0","JSS 3","","FRENCH LANGUAGE","15","10","10","9","9","","","","","","","38","32","70","70","0","","","5th","B2","VERY GOOD","MR MUYIWA","VERY GOOD, WELL DONE","0","100","5","5","5","5","5","5","5","5","5","5","submit","2021/2022","2nd Term");




CREATE TABLE `result_subject_group_assign` (
  `result_subject_group_assign_id` int(11) NOT NULL AUTO_INCREMENT,
  `result_subject_group_id` int(11) NOT NULL,
  `subject_id` int(11) NOT NULL,
  PRIMARY KEY (`result_subject_group_assign_id`),
  KEY `result_subject_group_id` (`result_subject_group_id`,`subject_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;






CREATE TABLE `result_subject_groups` (
  `result_subject_group_id` int(11) NOT NULL AUTO_INCREMENT,
  `result_subject_group_name` varchar(300) NOT NULL,
  `date_created` datetime NOT NULL DEFAULT current_timestamp(),
  PRIMARY KEY (`result_subject_group_id`),
  UNIQUE KEY `result_subject_group_name` (`result_subject_group_name`),
  KEY `date_created` (`date_created`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;






CREATE TABLE `salary_deduct` (
  `salary_deduct_id` int(11) NOT NULL AUTO_INCREMENT,
  `staff_id` int(11) NOT NULL,
  `amount` decimal(15,2) NOT NULL,
  `reason` varchar(400) NOT NULL,
  `sessions` varchar(20) NOT NULL,
  `terms` varchar(20) NOT NULL,
  `months` varchar(30) NOT NULL,
  PRIMARY KEY (`salary_deduct_id`),
  KEY `staff_id` (`staff_id`),
  KEY `sessions` (`sessions`),
  KEY `terms` (`terms`),
  KEY `months` (`months`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;






CREATE TABLE `salary_info` (
  `salary_info_id` int(11) NOT NULL AUTO_INCREMENT,
  `staff_id` int(11) NOT NULL,
  `current_salary` decimal(15,2) NOT NULL,
  `past_debt` decimal(15,2) NOT NULL,
  `amount_to_pay` decimal(15,2) NOT NULL,
  `amount_paid` decimal(15,2) NOT NULL,
  `wave_over` decimal(15,2) NOT NULL,
  `current_debt` decimal(15,2) NOT NULL,
  `deduct` decimal(15,2) NOT NULL,
  `appreciation_amount` decimal(15,2) NOT NULL,
  `appreciation_reason` varchar(500) NOT NULL,
  `owing` decimal(15,2) NOT NULL,
  `sessions` varchar(20) NOT NULL,
  `terms` varchar(20) NOT NULL,
  `months` varchar(30) NOT NULL,
  PRIMARY KEY (`salary_info_id`),
  KEY `staff_id` (`staff_id`),
  KEY `sessions` (`sessions`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;






CREATE TABLE `salary_payment` (
  `salary_payment_id` int(11) NOT NULL AUTO_INCREMENT,
  `staff_id` int(11) NOT NULL,
  `accountant_id` int(10) unsigned NOT NULL,
  `amount_paid` decimal(15,2) NOT NULL,
  `staff_name` varchar(200) NOT NULL,
  `sessions` varchar(20) NOT NULL,
  `terms` varchar(20) NOT NULL,
  `months` varchar(30) NOT NULL,
  `date_added` datetime NOT NULL,
  PRIMARY KEY (`salary_payment_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;






CREATE TABLE `school_fees` (
  `school_fees_id` int(11) NOT NULL AUTO_INCREMENT,
  `transaction_id` char(20) NOT NULL,
  `student_id` int(11) NOT NULL,
  `staff_id` int(11) NOT NULL,
  `plan_id` int(11) NOT NULL,
  `school_fees_payment_mode_id` int(11) NOT NULL,
  `payment_mode` varchar(300) NOT NULL,
  `staff_name` varchar(200) NOT NULL,
  `amount_paid` decimal(15,2) NOT NULL,
  `payment_no` varchar(20) NOT NULL,
  `payment_date` date NOT NULL,
  `fees_status` varchar(20) NOT NULL,
  `sessions` varchar(20) NOT NULL,
  `terms` varchar(10) NOT NULL,
  `date_added` datetime NOT NULL,
  PRIMARY KEY (`school_fees_id`),
  KEY `sessions` (`sessions`),
  KEY `terms` (`terms`),
  KEY `transaction_id` (`transaction_id`),
  KEY `school_fees_payment_mode_id` (`school_fees_payment_mode_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;






CREATE TABLE `school_fees_payment_modes` (
  `school_fees_payment_mode_id` int(11) NOT NULL AUTO_INCREMENT,
  `payment_mode` varchar(300) NOT NULL,
  `date_created` datetime NOT NULL DEFAULT current_timestamp(),
  PRIMARY KEY (`school_fees_payment_mode_id`),
  UNIQUE KEY `payment_mode` (`payment_mode`),
  KEY `date_created` (`date_created`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;






CREATE TABLE `school_storages` (
  `school_storage_id` int(11) NOT NULL AUTO_INCREMENT,
  `school_storage_title` varchar(200) NOT NULL,
  `school_storage_dir` varchar(500) NOT NULL,
  `school_storage_date` datetime NOT NULL,
  PRIMARY KEY (`school_storage_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;






CREATE TABLE `sent_sms` (
  `sent_sms_id` int(11) NOT NULL AUTO_INCREMENT,
  `unit_spent` varchar(300) NOT NULL,
  `message` text NOT NULL,
  `people` text NOT NULL,
  `date_sent` datetime NOT NULL,
  PRIMARY KEY (`sent_sms_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;






CREATE TABLE `session_month` (
  `session_month_id` int(11) NOT NULL AUTO_INCREMENT,
  `sessions` varchar(20) NOT NULL,
  `terms` varchar(20) NOT NULL,
  `months` varchar(30) NOT NULL,
  PRIMARY KEY (`session_month_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;






CREATE TABLE `session_term` (
  `session_term_id` int(11) NOT NULL AUTO_INCREMENT,
  `sessions` varchar(20) NOT NULL,
  `terms` varchar(20) NOT NULL,
  PRIMARY KEY (`session_term_id`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=latin1;


INSERT INTO session_term VALUES
("4","2021/2022","1st Term"),
("5","2021/2022","2nd Term");




CREATE TABLE `sessions` (
  `sid` varchar(40) NOT NULL,
  `expiry` int(10) unsigned NOT NULL,
  `data` text NOT NULL,
  `date_added` datetime NOT NULL DEFAULT current_timestamp(),
  PRIMARY KEY (`sid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;






CREATE TABLE `settings` (
  `settings_id` int(11) NOT NULL AUTO_INCREMENT,
  `setting_name` varchar(300) NOT NULL,
  `setting_value` varchar(300) NOT NULL,
  PRIMARY KEY (`settings_id`),
  KEY `setting_name` (`setting_name`)
) ENGINE=InnoDB AUTO_INCREMENT=97 DEFAULT CHARSET=latin1;


INSERT INTO settings VALUES
("1","total_sms","100"),
("2","school_name","KK INTERNATIONAL"),
("3","school_login_logo","assets/images/logo.png"),
("4","login_attempt","30"),
("5","holiday_project","yes"),
("6","cumulate_test","yes"),
("7","show_test","yes"),
("8","show_waec","yes"),
("9","show_neco","yes"),
("10","lower_ca_score","30"),
("11","lower_exam_score","70"),
("12","school_phonenumber","2340000000000"),
("13","teacher_subclass","yes"),
("14","country","NIGERIA"),
("15","country_code","234"),
("16","phonenumber_length","10"),
("17","full_phonenumber_length","11"),
("18","main_phonenumber_length","13"),
("19","one_sms_amount","3"),
("20","result_cumulative","yes"),
("21","result_school_fees","no"),
("22","school_address","PLOT 126 EXT 111, PHASE 2 SITE 1 KUBWA, ABUJA"),
("23","principal_finance","no"),
("24","one_card_amount","1000"),
("25","principal_name","SCHOOL HEAD"),
("26","principal_signature","images/principal_signatures/022ddb.png"),
("27","third_term_lower","no"),
("28","third_term_higher","no"),
("29","allow_finance","no"),
("30","order_class","no"),
("31","online_school_fees_payment","no"),
("32","sms_sender","NO NAME"),
("33","school_email","school@mail.com"),
("34","school_email_password","DÓ¬øÇÍÕ³J©A#ÏÌÏ"),
("35","school_email_name","School Name"),
("36","scratch_card","no"),
("37","higher_ca_score","30"),
("38","higher_exam_score","70"),
("39","class_approval","no"),
("40","allow_hostel","no"),
("41","result_attendance","no"),
("42","second_principal_signature","images/principal_signatures/f8360f.png"),
("43","lower_no_of_ca","1"),
("44","higher_no_of_ca","1"),
("45","lower_ca1","40"),
("46","lower_ca2","0"),
("47","lower_ca3","0"),
("48","lower_ca4","0"),
("49","lower_ca5","0"),
("50","lower_ca6","0"),
("51","higher_ca1","40"),
("52","higher_ca2","0"),
("53","higher_ca3","0"),
("54","higher_ca4","0"),
("55","higher_ca5","0"),
("56","higher_ca6","0"),
("57","lower_ca_name_1","CA"),
("58","lower_ca_name_2","CA 2"),
("59","lower_ca_name_3","CA 3"),
("60","lower_ca_name_4","CA 4"),
("61","lower_ca_name_5","CA 5"),
("62","lower_ca_name_6","CA 6"),
("63","higher_ca_name_1","CA"),
("64","higher_ca_name_2","CA 2"),
("65","higher_ca_name_3","CA 3"),
("66","higher_ca_name_4","CA 4"),
("67","higher_ca_name_5","CA 5"),
("68","higher_ca_name_6","CA 6"),
("69","lower_exam_name","Exam"),
("70","higher_exam_name","Exam"),
("71","main_school_id","1"),
("72","school_id","1"),
("73","school_storage","yes"),
("74","class_storage","yes"),
("75","class_teacher_comment_setting","yes"),
("76","student_affairs","no"),
("77","admission_number","no"),
("78","admission_format",""),
("79","paystack_subaccount","ACCT_t3w6pmnwzvmv2np"),
("80","currency","&#8358;"),
("81","annual_position_for_last_term","yes"),
("82","annual_only_last_subjects","no"),
("83","parent_finance","yes"),
("84","third_term_in_annual","no"),
("85","admin_class_check_result","yes"),
("86","refresh_token","1//050SH4EtODsccCgYIARAAGAUSNwF-L9Irppe_Bv2rl35Mkj_CsbQEnCFFKltUjnWiPalTUqfLeXyBcZNM05DkpzD5NJ3CFyfFfUM"),
("87","folder_id",""),
("88","google_client_id","150277175744-n19rn2vsuio1lt7ot1cirgvfp3ehjp2l.apps.googleusercontent.com"),
("89","google_client_secret","eTWa1cXmNcG-Ky2h32o7bv4n"),
("90","online_class","no"),
("91","payment_warning","no"),
("92","instalmental_payment","yes"),
("93","classroom_materials","no"),
("94","class_activity_name","CLASS ACTIVITY"),
("95","upload_admission_form","yes"),
("96","admit_student_button","yes");




CREATE TABLE `sms_account` (
  `sms_account_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `transaction_id` varchar(20) NOT NULL,
  `unit_bought` int(10) unsigned NOT NULL,
  `amount` varchar(20) NOT NULL,
  `status` varchar(20) NOT NULL,
  `mode` varchar(20) NOT NULL,
  `date_bought` datetime NOT NULL,
  PRIMARY KEY (`sms_account_id`),
  UNIQUE KEY `transaction_id` (`transaction_id`),
  KEY `mode` (`mode`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;






CREATE TABLE `staff` (
  `staff_id` int(11) NOT NULL AUTO_INCREMENT,
  `school_id` int(10) unsigned NOT NULL,
  `user_key` varchar(100) DEFAULT NULL,
  `serial_number` varchar(200) NOT NULL,
  `pass` varchar(255) NOT NULL,
  `first_password` varchar(200) NOT NULL,
  `new_password` varchar(255) NOT NULL,
  `first_name` varchar(200) NOT NULL,
  `other_name` varchar(200) NOT NULL,
  `last_name` varchar(100) NOT NULL,
  `gender` varchar(10) NOT NULL,
  `status` varchar(50) NOT NULL,
  `groups` varchar(20) NOT NULL,
  `position` varchar(200) NOT NULL,
  `student_affairs` varchar(20) NOT NULL,
  `address` varchar(200) NOT NULL,
  `dob` date NOT NULL,
  `phone_number` bigint(20) unsigned NOT NULL,
  `email` varchar(200) NOT NULL,
  `country` varchar(200) NOT NULL,
  `state_origin` varchar(200) NOT NULL,
  `religion` varchar(50) NOT NULL,
  `disability` varchar(300) NOT NULL,
  `passport` varchar(200) NOT NULL,
  `form` varchar(5) NOT NULL,
  `sent_serial_pass_sms` char(3) NOT NULL,
  `forget_token` varchar(200) NOT NULL,
  `login_attempt` int(11) NOT NULL,
  `login_last_time` int(11) unsigned NOT NULL,
  `skip` varchar(5) NOT NULL,
  `activation` varchar(50) NOT NULL,
  `year_of_employment` varchar(15) NOT NULL,
  `term_of_employment` varchar(15) NOT NULL,
  PRIMARY KEY (`staff_id`),
  UNIQUE KEY `user_key` (`user_key`),
  KEY `activation` (`activation`),
  KEY `serial_number` (`serial_number`),
  KEY `status` (`status`),
  KEY `religion` (`religion`),
  KEY `sent_serial_pass_sms` (`sent_serial_pass_sms`),
  KEY `skip` (`skip`),
  KEY `school_id` (`school_id`)
) ENGINE=InnoDB AUTO_INCREMENT=17 DEFAULT CHARSET=latin1;


INSERT INTO staff VALUES
("1","189","11898184e033","T/21/0001","$2y$10$mtLcJYHwdbSWzlYI0aXbjOsbXeQhLQWrKpNFpztULxuU7urFmvUW.","onglobal","onglobal","GLOBAL","","ZEON","male","academic","both","","","ABIA STATE","2021-12-15","2340000000000","","NIGERIA","ABIA","Christianity","","","","","","0","1649064500","","activated","2021/2022","1st Term"),
("2","189","21893382e2d8","T/21/0002","$2y$10$ZY9xhJL7XOZGxbNttA9/GeWDjBhN9CRfXYJR/nwr67JymqQUVhQU6","wumercy","wumercy","MERCY","","NWACHUKWU","female","academic","both","","","KUBWA","2021-12-15","2348032288634","","NIGERIA","ABIA","Christianity","","","form","","","0","1649162501","","activated","2021/2022","1st Term"),
("3","189","318974fc6ae4","T/21/0003","$2y$10$cF.S/4ZUYj2AAHoLrMmXqOa8grta51n6qdZnlHbvFuhHt.pKBWoqa","wubeatrice","wubeatrice","BEATRICE","EZINNE","CHUKWU","female","academic","both","","","KUBWA","2021-12-16","2348032209590","chukwubeatrice111@gmail.com","NIGERIA","FCT","Christianity","","","","","","0","1648748616","","activated","2021/2022","1st Term"),
("4","189","41892ed114b9","T/21/0004","$2y$10$vzzi0DYDHtUByejJ.VdVBup.p0A6g/ogd/IJbmZ3uaB30FPVMmobm","wunneka","wunneka","NNEKA","CHIKAODILI","CHUKWU","female","academic","both","","","KUBWA","2021-12-16","2348033636454","ChukwuNnekaa@gmail.com","NIGERIA","FCT","Christianity","MEDICALLY FIT","","form","","","0","1649692629","","activated","2021/2022","1st Term"),
("5","189","5189d1b40a1d","T/21/0005","$2y$10$nTsAMbgBlUgU0Y3DOyHxYea213O/xvp5qgV3Jf9.Vlweq3RmtH5uu","buhajara","buhajara","HAJARA","","YAKUBU","female","academic","both","","","KUBWA","2021-12-17","2340000000022","","NIGERIA","FCT","Christianity","","","","","","0","0","","activated","2021/2022","1st Term"),
("6","189","618943c1a60b","T/21/0006","$2y$10$cSDMHPR54OsiPMW9GtsKwe130Z5/.b/LOA3T6ry.sWoX29Y95U9ti","mrmuyiwa","mrmuyiwa","MUYIWA","","MR","male","academic","both","","","KUBWA","2021-12-09","2340000000000","","NIGERIA","EKITI","Christianity","","","","","","0","1649141637","","activated","2021/2022","1st Term"),
("14","189","141892c2473c0","T/21/0007","$2y$10$6DxkQjfzRkn4lZo.tomZSuGMLWu98vJU9ZTSKWeN95IkDWfUSJji.","rsokpeaji","rsokpeaji","OKPEAJI","","MRS","female","academic","both","","","KUBWA","2021-12-14","2341234567899","noemail@gmail.com","NIGERIA","BENUE","Christianity","FIT","","","","","0","1649124743","","activated","2021/2022","1st Term"),
("15","189","15189443f89c6","T/21/0008","$2y$10$qfJlNtvfx2BgIyVmCRfqW.79ZZVFZd2esCJHBSwbHesdln9aa9yOG","wouche","wouche","UCHE","","OKONKWO","male","academic","both","","","KUBWA","2022-02-03","2349045688321","noemail@gmail.com","NIGERIA","ANAMBRA","Christianity","none","","","","","0","0","","activated","2021/2022","1st Term"),
("16","189","16189c7157bbc","T/21/0009","$2y$10$odIILG22TZuNAt9z5luGWe9eO/4HVpr0TawqFy7WCwriXRqqzYOwu","hiogechi","hiogechi","OGECHI","MERCY","ONYEMECHI","female","academic","both","","","PLOT 2, OPP NPA 2/1 QUARTERS, PHASE 2, KUBWA","2021-12-13","2348060215859","","NIGERIA","ABIA","Christianity","MEDICALLY FIT","","form","","","0","1649145992","","activated","2021/2022","2nd Term");




CREATE TABLE `staff_salary` (
  `staff_salary_id` int(11) NOT NULL AUTO_INCREMENT,
  `staff_id` int(11) NOT NULL,
  `amount` decimal(15,2) NOT NULL,
  PRIMARY KEY (`staff_salary_id`)
) ENGINE=InnoDB AUTO_INCREMENT=17 DEFAULT CHARSET=latin1;


INSERT INTO staff_salary VALUES
("1","1","0.00"),
("2","2","0.00"),
("3","3","0.00"),
("4","4","0.00"),
("5","5","0.00"),
("6","6","0.00"),
("14","14","0.00"),
("15","15","0.00"),
("16","16","0.00");




CREATE TABLE `staff_subject` (
  `staff_subject_id` int(11) NOT NULL AUTO_INCREMENT,
  `staff_id` int(11) NOT NULL,
  `subject_id` int(11) NOT NULL,
  `class_id` int(11) NOT NULL,
  PRIMARY KEY (`staff_subject_id`),
  KEY `staff_subject_class` (`staff_id`,`subject_id`,`class_id`)
) ENGINE=InnoDB AUTO_INCREMENT=71 DEFAULT CHARSET=latin1;


INSERT INTO staff_subject VALUES
("3","0","1","4"),
("5","0","1","5"),
("6","0","1","6"),
("59","1","14","1"),
("44","1","14","2"),
("61","1","14","3"),
("55","1","18","1"),
("49","1","18","2"),
("51","1","18","3"),
("54","2","1","1"),
("39","2","1","2"),
("50","2","1","3"),
("56","2","2","1"),
("46","2","2","2"),
("52","2","2","3"),
("57","2","3","1"),
("47","2","3","2"),
("53","2","3","3"),
("68","3","4","1"),
("69","3","4","2"),
("70","3","4","3"),
("30","3","9","1"),
("37","3","9","2"),
("11","3","9","3"),
("26","4","5","1"),
("34","4","5","2"),
("8","4","5","3"),
("27","4","6","1"),
("35","4","6","2"),
("9","4","6","3"),
("29","4","8","1"),
("36","4","8","2"),
("10","4","8","3"),
("28","5","7","1"),
("48","5","7","2"),
("64","5","7","3"),
("60","5","16","1"),
("32","5","16","2"),
("62","5","16","3"),
("66","6","15","1"),
("45","6","15","2"),
("67","6","15","3"),
("22","14","10","1"),
("40","14","10","2"),
("12","14","10","3"),
("23","14","11","1"),
("41","14","11","2"),
("13","14","11","3"),
("24","14","12","1"),
("42","14","12","2"),
("14","14","12","3"),
("25","14","13","1"),
("43","14","13","2"),
("15","14","13","3"),
("58","16","17","1"),
("38","16","17","2"),
("63","16","17","3");




CREATE TABLE `staff_subject_subclass` (
  `staff_subject_subclass_id` int(11) NOT NULL AUTO_INCREMENT,
  `staff_id` int(11) NOT NULL,
  `subject_id` int(11) NOT NULL,
  `class_id` int(11) NOT NULL,
  `subclass_id` int(11) NOT NULL,
  PRIMARY KEY (`staff_subject_subclass_id`),
  UNIQUE KEY `staff_subject_subclass` (`staff_id`,`subject_id`,`class_id`,`subclass_id`)
) ENGINE=InnoDB AUTO_INCREMENT=71 DEFAULT CHARSET=latin1;


INSERT INTO staff_subject_subclass VALUES
("3","0","1","4","0"),
("5","0","1","5","0"),
("6","0","1","6","0"),
("59","1","14","1","0"),
("44","1","14","2","0"),
("61","1","14","3","0"),
("55","1","18","1","0"),
("49","1","18","2","0"),
("51","1","18","3","0"),
("54","2","1","1","0"),
("39","2","1","2","0"),
("50","2","1","3","0"),
("56","2","2","1","0"),
("46","2","2","2","0"),
("52","2","2","3","0"),
("57","2","3","1","0"),
("47","2","3","2","0"),
("53","2","3","3","0"),
("68","3","4","1","0"),
("69","3","4","2","0"),
("70","3","4","3","0"),
("30","3","9","1","0"),
("37","3","9","2","0"),
("11","3","9","3","0"),
("26","4","5","1","0"),
("34","4","5","2","0"),
("8","4","5","3","0"),
("27","4","6","1","0"),
("35","4","6","2","0"),
("9","4","6","3","0"),
("29","4","8","1","0"),
("36","4","8","2","0"),
("10","4","8","3","0"),
("28","5","7","1","0"),
("48","5","7","2","0"),
("64","5","7","3","0"),
("60","5","16","1","0"),
("32","5","16","2","0"),
("62","5","16","3","0"),
("66","6","15","1","0"),
("45","6","15","2","0"),
("67","6","15","3","0"),
("22","14","10","1","0"),
("40","14","10","2","0"),
("12","14","10","3","0"),
("23","14","11","1","0"),
("41","14","11","2","0"),
("13","14","11","3","0"),
("24","14","12","1","0"),
("42","14","12","2","0"),
("14","14","12","3","0"),
("25","14","13","1","0"),
("43","14","13","2","0"),
("15","14","13","3","0"),
("58","16","17","1","0"),
("38","16","17","2","0"),
("63","16","17","3","0");




CREATE TABLE `student_plan` (
  `student_plan_id` int(11) NOT NULL AUTO_INCREMENT,
  `student_id` int(11) NOT NULL,
  `plan_id` int(11) NOT NULL,
  PRIMARY KEY (`student_plan_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;






CREATE TABLE `student_subject` (
  `student_subject_id` int(11) NOT NULL AUTO_INCREMENT,
  `student_id` int(11) NOT NULL,
  `subject_id` int(11) NOT NULL,
  `status` varchar(10) NOT NULL,
  PRIMARY KEY (`student_subject_id`),
  KEY `student_subject_status` (`student_id`,`subject_id`,`status`)
) ENGINE=InnoDB AUTO_INCREMENT=778 DEFAULT CHARSET=latin1;


INSERT INTO student_subject VALUES
("560","1","1","doing"),
("562","1","2","doing"),
("563","1","3","doing"),
("726","1","4","doing"),
("176","1","5","doing"),
("177","1","6","doing"),
("178","1","7","not_doing"),
("179","1","8","doing"),
("180","1","9","doing"),
("172","1","10","doing"),
("173","1","11","doing"),
("174","1","12","doing"),
("175","1","13","doing"),
("630","1","14","doing"),
("704","1","15","doing"),
("631","1","16","doing"),
("616","1","17","doing"),
("561","1","18","doing"),
("564","2","1","doing"),
("566","2","2","doing"),
("567","2","3","doing"),
("727","2","4","doing"),
("185","2","5","doing"),
("186","2","6","doing"),
("187","2","7","doing"),
("188","2","8","doing"),
("189","2","9","doing"),
("181","2","10","doing"),
("182","2","11","doing"),
("183","2","12","doing"),
("184","2","13","not_doing"),
("632","2","14","doing"),
("705","2","15","doing"),
("633","2","16","doing"),
("617","2","17","doing"),
("565","2","18","doing"),
("568","3","1","doing"),
("570","3","2","doing"),
("571","3","3","doing"),
("728","3","4","doing"),
("194","3","5","doing"),
("195","3","6","doing"),
("196","3","7","not_doing"),
("197","3","8","doing"),
("198","3","9","doing"),
("190","3","10","doing"),
("191","3","11","doing"),
("192","3","12","doing"),
("193","3","13","doing"),
("634","3","14","doing"),
("706","3","15","doing"),
("635","3","16","doing"),
("618","3","17","doing"),
("569","3","18","doing"),
("572","4","1","doing"),
("574","4","2","doing"),
("575","4","3","doing"),
("729","4","4","doing"),
("203","4","5","doing"),
("204","4","6","doing"),
("205","4","7","not_doing"),
("206","4","8","doing"),
("207","4","9","doing"),
("199","4","10","doing"),
("200","4","11","doing"),
("201","4","12","doing"),
("202","4","13","doing"),
("636","4","14","doing"),
("707","4","15","doing"),
("637","4","16","doing"),
("619","4","17","doing"),
("573","4","18","doing"),
("576","5","1","doing"),
("578","5","2","doing"),
("579","5","3","doing"),
("730","5","4","doing"),
("212","5","5","doing"),
("213","5","6","doing"),
("214","5","7","doing"),
("215","5","8","doing"),
("216","5","9","doing"),
("208","5","10","doing"),
("209","5","11","doing"),
("210","5","12","doing"),
("211","5","13","not_doing"),
("638","5","14","doing"),
("708","5","15","doing"),
("639","5","16","doing"),
("620","5","17","doing"),
("577","5","18","doing"),
("580","6","1","doing"),
("582","6","2","doing"),
("583","6","3","doing"),
("731","6","4","doing"),
("221","6","5","doing"),
("222","6","6","doing"),
("223","6","7","doing"),
("224","6","8","doing"),
("225","6","9","doing"),
("217","6","10","doing");
INSERT INTO student_subject VALUES
("218","6","11","doing"),
("219","6","12","doing"),
("220","6","13","not_doing"),
("640","6","14","doing"),
("709","6","15","doing"),
("641","6","16","doing"),
("621","6","17","doing"),
("581","6","18","doing"),
("584","7","1","doing"),
("586","7","2","doing"),
("587","7","3","doing"),
("732","7","4","doing"),
("230","7","5","doing"),
("231","7","6","doing"),
("232","7","7","not_doing"),
("233","7","8","doing"),
("234","7","9","doing"),
("226","7","10","doing"),
("227","7","11","doing"),
("228","7","12","doing"),
("229","7","13","doing"),
("642","7","14","doing"),
("710","7","15","doing"),
("643","7","16","doing"),
("622","7","17","doing"),
("585","7","18","doing"),
("588","8","1","doing"),
("590","8","2","doing"),
("591","8","3","doing"),
("733","8","4","doing"),
("239","8","5","doing"),
("240","8","6","doing"),
("241","8","7","not_doing"),
("242","8","8","doing"),
("243","8","9","doing"),
("235","8","10","doing"),
("236","8","11","doing"),
("237","8","12","doing"),
("238","8","13","doing"),
("644","8","14","doing"),
("711","8","15","doing"),
("645","8","16","doing"),
("623","8","17","doing"),
("589","8","18","doing"),
("592","9","1","doing"),
("594","9","2","doing"),
("595","9","3","doing"),
("734","9","4","doing"),
("248","9","5","doing"),
("249","9","6","doing"),
("250","9","7","not_doing"),
("251","9","8","doing"),
("252","9","9","doing"),
("244","9","10","doing"),
("245","9","11","doing"),
("246","9","12","doing"),
("247","9","13","doing"),
("646","9","14","doing"),
("712","9","15","doing"),
("647","9","16","doing"),
("624","9","17","doing"),
("593","9","18","doing"),
("596","10","1","doing"),
("598","10","2","doing"),
("599","10","3","doing"),
("735","10","4","doing"),
("257","10","5","doing"),
("258","10","6","doing"),
("259","10","7","not_doing"),
("260","10","8","doing"),
("261","10","9","doing"),
("253","10","10","doing"),
("254","10","11","doing"),
("255","10","12","doing"),
("256","10","13","doing"),
("648","10","14","doing"),
("713","10","15","doing"),
("649","10","16","doing"),
("625","10","17","doing"),
("597","10","18","doing"),
("600","11","1","doing"),
("602","11","2","doing"),
("603","11","3","doing"),
("736","11","4","doing"),
("266","11","5","doing"),
("267","11","6","doing"),
("268","11","7","not_doing"),
("269","11","8","doing"),
("270","11","9","doing"),
("262","11","10","doing"),
("263","11","11","doing"),
("264","11","12","doing"),
("265","11","13","doing"),
("650","11","14","doing"),
("714","11","15","doing"),
("651","11","16","doing"),
("626","11","17","doing"),
("601","11","18","doing"),
("604","12","1","doing"),
("606","12","2","doing");
INSERT INTO student_subject VALUES
("607","12","3","doing"),
("737","12","4","doing"),
("275","12","5","doing"),
("276","12","6","doing"),
("277","12","7","not_doing"),
("278","12","8","doing"),
("279","12","9","doing"),
("271","12","10","doing"),
("272","12","11","doing"),
("273","12","12","doing"),
("274","12","13","doing"),
("652","12","14","doing"),
("715","12","15","doing"),
("653","12","16","doing"),
("627","12","17","doing"),
("605","12","18","doing"),
("608","13","1","doing"),
("610","13","2","doing"),
("611","13","3","doing"),
("738","13","4","doing"),
("284","13","5","doing"),
("285","13","6","doing"),
("286","13","7","not_doing"),
("287","13","8","doing"),
("288","13","9","doing"),
("280","13","10","doing"),
("281","13","11","doing"),
("282","13","12","doing"),
("283","13","13","doing"),
("654","13","14","doing"),
("716","13","15","doing"),
("655","13","16","doing"),
("628","13","17","doing"),
("609","13","18","doing"),
("612","14","1","doing"),
("614","14","2","doing"),
("615","14","3","doing"),
("739","14","4","doing"),
("293","14","5","doing"),
("294","14","6","doing"),
("295","14","7","not_doing"),
("296","14","8","doing"),
("297","14","9","doing"),
("289","14","10","doing"),
("290","14","11","doing"),
("291","14","12","doing"),
("292","14","13","doing"),
("656","14","14","doing"),
("717","14","15","doing"),
("657","14","16","doing"),
("629","14","17","doing"),
("613","14","18","doing"),
("396","15","1","doing"),
("403","15","2","doing"),
("404","15","3","doing"),
("740","15","4","doing"),
("314","15","5","doing"),
("315","15","6","doing"),
("405","15","7","not_doing"),
("316","15","8","doing"),
("317","15","9","doing"),
("397","15","10","doing"),
("398","15","11","doing"),
("399","15","12","doing"),
("400","15","13","doing"),
("401","15","14","doing"),
("402","15","15","doing"),
("312","15","16","doing"),
("378","15","17","doing"),
("516","15","18","doing"),
("406","16","1","doing"),
("413","16","2","doing"),
("414","16","3","doing"),
("741","16","4","doing"),
("320","16","5","doing"),
("321","16","6","doing"),
("415","16","7","not_doing"),
("322","16","8","doing"),
("323","16","9","doing"),
("407","16","10","doing"),
("408","16","11","doing"),
("409","16","12","doing"),
("410","16","13","doing"),
("411","16","14","doing"),
("412","16","15","doing"),
("318","16","16","doing"),
("379","16","17","doing"),
("517","16","18","doing"),
("416","17","1","doing"),
("423","17","2","doing"),
("424","17","3","doing"),
("742","17","4","doing"),
("326","17","5","doing"),
("327","17","6","doing"),
("425","17","7","not_doing"),
("328","17","8","doing"),
("329","17","9","doing"),
("417","17","10","doing"),
("418","17","11","doing"),
("419","17","12","doing");
INSERT INTO student_subject VALUES
("420","17","13","doing"),
("421","17","14","doing"),
("422","17","15","doing"),
("324","17","16","doing"),
("380","17","17","doing"),
("518","17","18","doing"),
("426","18","1","doing"),
("433","18","2","doing"),
("434","18","3","doing"),
("743","18","4","doing"),
("332","18","5","doing"),
("333","18","6","doing"),
("435","18","7","not_doing"),
("334","18","8","doing"),
("335","18","9","doing"),
("427","18","10","doing"),
("428","18","11","doing"),
("429","18","12","doing"),
("430","18","13","doing"),
("431","18","14","doing"),
("432","18","15","doing"),
("330","18","16","doing"),
("381","18","17","doing"),
("519","18","18","doing"),
("436","19","1","doing"),
("443","19","2","doing"),
("444","19","3","doing"),
("744","19","4","doing"),
("338","19","5","doing"),
("339","19","6","doing"),
("445","19","7","not_doing"),
("340","19","8","doing"),
("341","19","9","doing"),
("437","19","10","doing"),
("438","19","11","doing"),
("439","19","12","doing"),
("440","19","13","doing"),
("441","19","14","doing"),
("442","19","15","doing"),
("336","19","16","doing"),
("382","19","17","doing"),
("520","19","18","doing"),
("446","20","1","doing"),
("453","20","2","doing"),
("454","20","3","doing"),
("745","20","4","doing"),
("344","20","5","doing"),
("345","20","6","doing"),
("455","20","7","not_doing"),
("346","20","8","doing"),
("347","20","9","doing"),
("447","20","10","doing"),
("448","20","11","doing"),
("449","20","12","doing"),
("450","20","13","doing"),
("451","20","14","doing"),
("452","20","15","doing"),
("342","20","16","doing"),
("383","20","17","doing"),
("521","20","18","doing"),
("456","21","1","doing"),
("463","21","2","doing"),
("464","21","3","doing"),
("746","21","4","doing"),
("350","21","5","doing"),
("351","21","6","doing"),
("465","21","7","not_doing"),
("352","21","8","doing"),
("353","21","9","doing"),
("457","21","10","doing"),
("458","21","11","doing"),
("459","21","12","doing"),
("460","21","13","doing"),
("461","21","14","doing"),
("462","21","15","doing"),
("348","21","16","doing"),
("384","21","17","doing"),
("522","21","18","doing"),
("466","22","1","doing"),
("473","22","2","doing"),
("474","22","3","doing"),
("747","22","4","doing"),
("356","22","5","doing"),
("357","22","6","doing"),
("475","22","7","doing"),
("358","22","8","doing"),
("359","22","9","doing"),
("467","22","10","doing"),
("468","22","11","doing"),
("469","22","12","doing"),
("470","22","13","not_doing"),
("471","22","14","doing"),
("472","22","15","doing"),
("354","22","16","doing"),
("385","22","17","doing"),
("523","22","18","doing"),
("476","23","1","doing"),
("483","23","2","doing"),
("484","23","3","doing"),
("748","23","4","doing");
INSERT INTO student_subject VALUES
("362","23","5","doing"),
("363","23","6","doing"),
("485","23","7","not_doing"),
("364","23","8","doing"),
("365","23","9","doing"),
("477","23","10","doing"),
("478","23","11","doing"),
("479","23","12","doing"),
("480","23","13","doing"),
("481","23","14","doing"),
("482","23","15","doing"),
("360","23","16","doing"),
("386","23","17","doing"),
("524","23","18","doing"),
("506","24","1","doing"),
("513","24","2","doing"),
("514","24","3","doing"),
("751","24","4","doing"),
("368","24","5","doing"),
("369","24","6","doing"),
("515","24","7","doing"),
("370","24","8","doing"),
("371","24","9","doing"),
("507","24","10","doing"),
("508","24","11","doing"),
("509","24","12","doing"),
("510","24","13","doing"),
("511","24","14","doing"),
("512","24","15","doing"),
("366","24","16","doing"),
("387","24","17","doing"),
("527","24","18","doing"),
("486","25","1","doing"),
("493","25","2","doing"),
("494","25","3","doing"),
("749","25","4","doing"),
("374","25","5","doing"),
("375","25","6","doing"),
("495","25","7","doing"),
("376","25","8","doing"),
("377","25","9","doing"),
("487","25","10","doing"),
("488","25","11","doing"),
("489","25","12","doing"),
("490","25","13","doing"),
("491","25","14","doing"),
("492","25","15","doing"),
("372","25","16","doing"),
("388","25","17","doing"),
("525","25","18","doing"),
("528","26","1","doing"),
("530","26","2","doing"),
("531","26","3","doing"),
("752","26","4","doing"),
("35","26","5","doing"),
("36","26","6","doing"),
("661","26","7","not_doing"),
("37","26","8","doing"),
("38","26","9","doing"),
("74","26","10","doing"),
("75","26","11","doing"),
("76","26","12","doing"),
("77","26","13","doing"),
("658","26","14","doing"),
("718","26","15","doing"),
("659","26","16","doing"),
("660","26","17","doing"),
("529","26","18","doing"),
("532","27","1","doing"),
("534","27","2","doing"),
("535","27","3","doing"),
("753","27","4","doing"),
("40","27","5","doing"),
("41","27","6","doing"),
("665","27","7","not_doing"),
("42","27","8","doing"),
("43","27","9","doing"),
("78","27","10","doing"),
("79","27","11","doing"),
("80","27","12","doing"),
("81","27","13","doing"),
("662","27","14","doing"),
("719","27","15","doing"),
("663","27","16","doing"),
("664","27","17","doing"),
("533","27","18","doing"),
("536","28","1","doing"),
("538","28","2","doing"),
("539","28","3","doing"),
("754","28","4","doing"),
("45","28","5","doing"),
("46","28","6","doing"),
("669","28","7","not_doing"),
("47","28","8","doing"),
("48","28","9","doing"),
("82","28","10","doing"),
("83","28","11","doing"),
("84","28","12","doing"),
("85","28","13","doing"),
("666","28","14","doing");
INSERT INTO student_subject VALUES
("720","28","15","doing"),
("667","28","16","doing"),
("668","28","17","doing"),
("537","28","18","doing"),
("540","29","1","doing"),
("542","29","2","doing"),
("543","29","3","doing"),
("755","29","4","doing"),
("50","29","5","doing"),
("51","29","6","doing"),
("673","29","7","doing"),
("52","29","8","doing"),
("53","29","9","doing"),
("86","29","10","doing"),
("87","29","11","doing"),
("88","29","12","doing"),
("89","29","13","not_doing"),
("670","29","14","doing"),
("721","29","15","doing"),
("671","29","16","doing"),
("672","29","17","doing"),
("541","29","18","doing"),
("544","30","1","doing"),
("546","30","2","doing"),
("547","30","3","doing"),
("756","30","4","doing"),
("55","30","5","doing"),
("56","30","6","doing"),
("677","30","7","not_doing"),
("57","30","8","doing"),
("58","30","9","doing"),
("90","30","10","doing"),
("91","30","11","doing"),
("92","30","12","doing"),
("93","30","13","doing"),
("674","30","14","doing"),
("722","30","15","doing"),
("675","30","16","doing"),
("676","30","17","doing"),
("545","30","18","doing"),
("548","31","1","doing"),
("550","31","2","doing"),
("551","31","3","doing"),
("757","31","4","doing"),
("60","31","5","doing"),
("61","31","6","doing"),
("681","31","7","not_doing"),
("62","31","8","doing"),
("63","31","9","doing"),
("94","31","10","doing"),
("95","31","11","doing"),
("96","31","12","doing"),
("97","31","13","doing"),
("678","31","14","doing"),
("723","31","15","doing"),
("679","31","16","doing"),
("680","31","17","doing"),
("549","31","18","doing"),
("552","32","1","doing"),
("554","32","2","doing"),
("555","32","3","doing"),
("758","32","4","doing"),
("65","32","5","doing"),
("66","32","6","doing"),
("685","32","7","not_doing"),
("67","32","8","doing"),
("68","32","9","doing"),
("98","32","10","doing"),
("99","32","11","doing"),
("100","32","12","doing"),
("101","32","13","doing"),
("682","32","14","doing"),
("724","32","15","doing"),
("683","32","16","doing"),
("684","32","17","doing"),
("553","32","18","doing"),
("556","33","1","doing"),
("558","33","2","doing"),
("559","33","3","doing"),
("759","33","4","doing"),
("70","33","5","doing"),
("71","33","6","doing"),
("689","33","7","not_doing"),
("72","33","8","doing"),
("73","33","9","doing"),
("102","33","10","doing"),
("103","33","11","doing"),
("104","33","12","doing"),
("105","33","13","doing"),
("686","33","14","doing"),
("725","33","15","doing"),
("687","33","16","doing"),
("688","33","17","doing"),
("557","33","18","doing"),
("496","34","1","doing"),
("503","34","2","doing"),
("504","34","3","doing"),
("750","34","4","doing"),
("391","34","5","doing"),
("392","34","6","doing");
INSERT INTO student_subject VALUES
("505","34","7","not_doing"),
("393","34","8","doing"),
("394","34","9","doing"),
("497","34","10","doing"),
("498","34","11","doing"),
("499","34","12","doing"),
("500","34","13","doing"),
("501","34","14","doing"),
("502","34","15","doing"),
("389","34","16","doing"),
("395","34","17","doing"),
("526","34","18","doing"),
("769","35","1","doing"),
("771","35","2","doing"),
("772","35","3","doing"),
("777","35","4","doing"),
("764","35","5","doing"),
("765","35","6","doing"),
("766","35","7","not_doing"),
("767","35","8","doing"),
("768","35","9","doing"),
("760","35","10","doing"),
("761","35","11","doing"),
("762","35","12","doing"),
("763","35","13","doing"),
("774","35","14","doing"),
("776","35","15","doing"),
("775","35","16","doing"),
("773","35","17","doing"),
("770","35","18","doing");




CREATE TABLE `students` (
  `student_id` int(11) NOT NULL AUTO_INCREMENT,
  `user_key` varchar(100) DEFAULT NULL,
  `school_id` int(10) unsigned NOT NULL,
  `parent_id` int(11) NOT NULL,
  `class_id` int(11) NOT NULL,
  `subclass_id` int(11) NOT NULL,
  `plan_id` int(11) NOT NULL,
  `hostel_id` int(11) NOT NULL,
  `room_id` int(11) NOT NULL,
  `bedspace` int(11) DEFAULT NULL,
  `first_name` varchar(50) NOT NULL,
  `other_name` varchar(50) NOT NULL,
  `last_name` varchar(50) NOT NULL,
  `serial_number` varchar(50) NOT NULL,
  `pass` char(255) NOT NULL,
  `first_password` varchar(200) NOT NULL,
  `new_password` varchar(200) NOT NULL,
  `email` varchar(200) NOT NULL,
  `dob` date NOT NULL,
  `gender` varchar(10) NOT NULL,
  `religion` varchar(50) NOT NULL,
  `reg_no` varchar(20) NOT NULL,
  `adm_no` varchar(60) NOT NULL,
  `graduation_year` varchar(20) NOT NULL,
  `graduation_term` varchar(10) NOT NULL,
  `deactivation_sess` char(20) NOT NULL,
  `deactivation_term` char(10) NOT NULL,
  `disability` varchar(300) NOT NULL,
  `passport` varchar(200) NOT NULL,
  `relationship` varchar(20) NOT NULL,
  `new_student` varchar(20) NOT NULL,
  `new_student_finance` varchar(20) NOT NULL,
  `forget_token` varchar(50) NOT NULL,
  `login_attempt` int(11) NOT NULL,
  `login_last_time` int(11) unsigned NOT NULL,
  `scratch_card_attempt` int(10) unsigned NOT NULL,
  `scratch_card_last_time` int(10) unsigned NOT NULL,
  `transfer` char(20) NOT NULL,
  `transfer_school_id` int(11) NOT NULL,
  `exempt` char(10) NOT NULL,
  `check_result` varchar(20) NOT NULL DEFAULT 'check_result',
  `activation` varchar(20) NOT NULL,
  `date_created` datetime NOT NULL DEFAULT current_timestamp(),
  PRIMARY KEY (`student_id`),
  UNIQUE KEY `serial_number` (`serial_number`),
  UNIQUE KEY `user_key` (`user_key`),
  KEY `activation` (`activation`),
  KEY `parent_id` (`parent_id`),
  KEY `plan_id` (`plan_id`),
  KEY `class_subclass` (`class_id`,`subclass_id`,`activation`),
  KEY `exempt` (`exempt`),
  KEY `check_result` (`check_result`),
  KEY `date_created` (`date_created`),
  KEY `school_id` (`school_id`)
) ENGINE=InnoDB AUTO_INCREMENT=36 DEFAULT CHARSET=latin1;


INSERT INTO students VALUES
("1","118966a54f4f","189","51","1","0","0","0","0","","STAR","","ABIAZIEM","S/21/0001","$2y$10$uovo.Rk/D5L3x5P.CBl6Nuv0US8gRT662tto8r2ZjMlIQYOmeHjoC","emstar","emstar","","2012-03-16","female","Christianity","","","","","","","","","","","","","0","0","0","0","","0","","check_result","activated","2021-12-15 13:19:06"),
("2","21894ae49de0","189","43","1","0","0","0","0","","ABBA","","ABDULRAZAQ","S/21/0002","$2y$10$EgUz6HrnUFRZisuesy00q.yMxFGH4tkSX6fiLtwblezXfODilkNc2","aqabba","aqabba","","2010-11-30","male","Christianity","","","","","","","","","PARENT","","","","0","0","0","0","","0","","check_result","activated","2021-12-15 13:20:00"),
("3","31896e54484a","189","33","1","0","0","0","0","","GODWIN","","AJIS","S/21/0003","$2y$10$0bVw2r1AJ7IAxyscwCeZ6u13PAKk51WnuL7C0QmqXvgLOu0ufiNUO","isgodwin","isgodwin","","2008-03-08","male","Christianity","","","","","","","","","","","","","0","0","0","0","","0","","check_result","activated","2021-12-15 13:20:56"),
("4","41899992c7e4","189","44","1","0","0","0","0","","PRAISE","","FANIBE","S/21/0004","$2y$10$8MYXYHtUbLzJxESWzWc0qOo5PW/FCIbphD4puyIWcfrWZnVIzdXD2","bepraise","bepraise","","2011-03-20","male","Christianity","","","","","","","","","","","","","0","0","0","0","","0","","check_result","activated","2021-12-15 13:21:50"),
("5","5189f588edae","189","21","1","0","0","0","0","","IBRAHIM","","SAFIRU","S/21/0005","$2y$10$L0an5sLZ5z9BbnOjxQDbmOg4CRm1IBMAUNumkTDq7NUoi.WkIFnYy","imsafiru","imsafiru","","2010-07-28","male","Christianity","","","","","","","","","","","","","0","0","0","0","","0","","check_result","activated","2021-12-15 13:24:08"),
("6","618933ba81fe","189","24","1","0","0","0","0","","HABIBA","BAKO","INUWA","S/21/0006","$2y$10$AGLM/RbznRqaUhUFC.mDWOggWu6JQGEYYQQsIeQpKZUp0jZDJq0.K","wahabiba","wahabiba","","2010-05-10","female","Christianity","","","","","","","","","","","","","0","0","0","0","","0","","check_result","activated","2021-12-15 13:25:16"),
("7","718911c5d651","189","45","1","0","0","0","0","","ELIJAH","","ISAAC","S/21/0007","$2y$10$dgUMDG0aC.A/R0jAQYVK8ufuLoEq8RsN8cd8fd.Sm28/sUY9BALwe","acelijah","acelijah","","2010-06-01","male","Christianity","","","","","","","","","","","","","0","0","0","0","","0","","check_result","activated","2021-12-15 13:26:33"),
("8","8189d4c124ff","189","45","1","0","0","0","0","","JOSEPH","","ISAAC","S/21/0008","$2y$10$b2qpCoSmc4cMYL6R9WbvqO5oYE.OsyJVkr4aN8.b.8ySv79AQGijy","acjoseph","acjoseph","","2010-06-01","male","Christianity","","","","","","","","","","","","","0","0","0","0","","0","","check_result","activated","2021-12-15 13:27:20"),
("9","9189c167fc55","189","46","1","0","0","0","0","","INALEGWU","","IYAH","S/21/0009","$2y$10$IFa.fBThPCZC7VOS0jBJTeTvm3.PErW.DwnQpQ88l/kfPTRgZewg2","ahinalegwu","ahinalegwu","","2009-09-10","male","Christianity","","","","","","","","","","","","","0","0","0","0","","0","","check_result","activated","2021-12-15 13:28:46"),
("10","101897ee0c358","189","47","1","0","0","0","0","","SOLOMON","","JUSTINE","S/21/0010","$2y$10$Jb1XuAsMShp7fUdB9ptFeOg7wcZOuQ8BkM9CMV2TEkVsI1/d1bfKO","nesolomon","nesolomon","","2011-01-30","male","Christianity","","","","","","","","","","","","","0","0","0","0","","0","","check_result","activated","2021-12-15 13:29:37"),
("11","11189512527b0","189","48","1","0","0","0","0","","BIBIAN","","OGWUCHE","S/21/0011","$2y$10$1xlrTZ3SX.NQVtrwOGLwj.ywG7IC4bVxtw34AUE0XgrdJ/hRA3h9C","hebibian","hebibian","","2012-10-04","female","Christianity","","","","","","","","","","","","","0","0","0","0","","0","","check_result","activated","2021-12-15 13:30:31"),
("12","1218938d73dbe","189","0","1","0","0","0","0","","SAMUEL","","OLONINIYI","S/21/0012","$2y$10$C/S09wiC51iMV3KQ19jj.OcYiLMVH7FqP.vawOk6nXlyCjN0gzlYK","yisamuel","yisamuel","","2010-11-04","male","Christianity","","","","","2021/2022","1st Term","","","","","","","0","0","0","0","","0","","check_result","deactivated","2021-12-15 13:31:27"),
("13","13189e352b765","189","49","1","0","0","0","0","","FRANCIS","","PATRICK","S/21/0013","$2y$10$LGu9aFCsiIjbWQA8aCBhiuH0v.pgZVGrjcsSoZgdlyNQiYAtmWUuy","ckfrancis","ckfrancis","","2007-02-08","male","Christianity","","","","","","","","","","","","","0","0","0","0","","0","","check_result","activated","2021-12-15 13:33:03"),
("14","141895969d75f","189","50","1","0","0","0","0","","ABDULHAMID","","USMAN","S/21/0014","$2y$10$XgSFzE/8cAAm2XdDwUy8z.E5intIOK030UoUkVNZCj180f6.u688a","anabdulhamid","anabdulhamid","","2011-10-28","male","Christianity","","","","","","","","","","","","","0","0","0","0","","0","","check_result","activated","2021-12-15 13:42:09"),
("15","15189fc827426","189","1","2","0","0","0","0","","FELIX","","ABENG","S/21/0015","$2y$10$XozLfox0z03BikeN58KC9.IRN.AwHMGwi4fCfaulChVOcwkAi4Tn.","zeonglobal","zeonglobal","","2021-12-15","male","Christianity","","","","","","","","","PARENT","","","","0","0","0","0","","0","","check_result","activated","2021-12-15 13:47:24"),
("16","161897c02e677","189","2","2","0","0","0","0","","SAMUEL","","ABRAHAM","S/21/0016","$2y$10$1IXOMX9y.P1i7Txlw9jcd.T3tlUHfWSMBTlQ767Hr0XsqfHLjZ85W","zeonglobal","zeonglobal","","2021-12-15","male","Christianity","","","","","","","","","PARENT","","","","0","0","0","0","","0","","check_result","activated","2021-12-15 13:49:18"),
("17","17189512ea006","189","3","2","0","0","0","0","","DEBORAH","","EMMANUEL","S/21/0017","$2y$10$lpZAJinFl6mPphO5RWsMQOEby2E.4CDUtT5sZa.EcCdmsEBjt0YMO","zeonglobal","zeonglobal","","2021-12-15","female","Christianity","","","","","","","","","PARENT","","","","0","0","0","0","","0","","check_result","activated","2021-12-15 13:50:49"),
("18","181897ac61ac6","189","4","2","0","0","0","0","","CHRISTIANA","","IBRAHIM","S/21/0018","$2y$10$yOtxkE1AmghXvxs61wG8U.k753Gzaq.oJ5sFYzEDuFpl0T1/mDUii","zeonglobal","zeonglobal","","2021-12-15","female","Christianity","","","","","","","","","PARENT","","","","0","0","0","0","","0","","check_result","activated","2021-12-15 13:53:22"),
("19","19189b094f2ee","189","5","2","0","0","0","0","","JEREMIAH","","ISIBOR","S/21/0019","$2y$10$O35lW.oBFZgAuEvzyT/8Aetu4E/YLlQXP83cpukU9YegaEVQ1KX2q","zeonglobal","zeonglobal","","2021-12-15","male","Christianity","","","","","","","","","PARENT","","","","0","0","0","0","","0","","check_result","activated","2021-12-15 13:55:04"),
("20","20189871e6011","189","6","2","0","0","0","0","","KARINATEI","IJANBOH","JOHN","S/21/0020","$2y$10$ee7Dx09i18FhtlmmKDlLXubkGeqUEOT1NZrfFd86Jlbj0n9xrtjvW","zeonglobal","zeonglobal","","2021-12-15","male","Christianity","","","","","","","","","PARENT","","","","0","0","0","0","","0","","check_result","activated","2021-12-15 13:56:43"),
("21","21189d3209fa9","189","7","2","0","0","0","0","","SUCCESS","","JOSEPH","S/21/0021","$2y$10$ecfcD9p8.39IWfcgpvCaceKEcckeZ6enlP6TEoEuueUIC5VdRLq56","zeonglobal","zeonglobal","","2021-12-15","male","Christianity","","","","","","","","","PARENT","","","","0","0","0","0","","0","","check_result","activated","2021-12-15 14:01:19"),
("22","221897f32363c","189","8","2","0","0","0","0","","ABDULMALIK","","KADI-MALA","S/21/0022","$2y$10$DYAoY4mUcy/pJi3TRAE7LOOwdysgmrxcaSkaZ8SdSNd5DyZV7r3xu","zeonglobal","zeonglobal","","2021-12-15","male","Christianity","","","","","","","","","PARENT","","","","0","0","0","0","","0","","check_result","activated","2021-12-15 14:03:37"),
("23","231899a0421ab","189","9","2","0","0","0","0","","CHIZIKORA","","OKPALENWE","S/21/0023","$2y$10$NtQDOCGYRa/GWGV6UJVpQ.30FzPJ.V4AzchP2/QqB.tqiee3J2S3K","zeonglobal","zeonglobal","","2021-12-15","female","Christianity","","","","","","","","","PARENT","","","","0","0","0","0","","0","","check_result","activated","2021-12-15 15:24:23"),
("24","241897f270cec","189","0","2","0","0","0","0","","JACOB","OWOICHO","OKPE-AJI","S/21/0024","$2y$10$sHEudmUw6ZvwGsdFv98FDengCA0ygqCDMcwib6C6mXraEH36OsBEa","zeonglobal","zeonglobal","","2021-12-15","male","Christianity","","","","","2021/2022","1st Term","","","PARENT","","","","0","0","0","0","","0","","check_result","deactivated","2021-12-15 15:27:31"),
("25","25189907f067e","189","11","2","0","0","0","0","","CHINAZA","EMMANUELLA","NWANTA","S/21/0025","$2y$10$rWEaQXhg1F5mstsE56u4KOuxAnS9OdCXPslQEMuGFbCffpUTbHiKK","zeonglobal","zeonglobal","","2021-12-15","female","Christianity","","","","","2021/2022","2nd Term","","","PARENT","","","","0","0","0","0","","0","","check_result","deactivated","2021-12-15 15:29:25"),
("26","261895a21c034","189","12","3","0","0","0","0","","DESTINY","AMARACHI","AZUBIKE","S/21/0026","$2y$10$xSOn3E1.xxWd5MVEwbQGTeU.2QrFR/NFhBL7XAn3fJUX40SOMqOjG","zeonglobal","zeonglobal","","2008-08-12","female","Christianity","","","","","","","","","PARENT","","","","0","0","0","0","","0","","check_result","activated","2021-12-15 21:39:53"),
("27","271899f11f167","189","12","3","0","0","0","0","","IKECHUKWU","SOLOMON","AZUBIKE","S/21/0027","$2y$10$vmAxRIRehckdG2uEzpXZdeggsyZzdQFPiujavw3N2qCzkM4yZDeRe","zeonglobal","zeonglobal","","2005-12-13","male","Christianity","","","","","","","","","PARENT","","","","0","0","0","0","","0","","check_result","activated","2021-12-15 22:41:19"),
("28","2818932a2a86a","189","14","3","0","0","0","0","","MARY-SCOTT","EFOLI","OFEM","S/21/0028","$2y$10$2Ny4JjoyFFoVFHoTkSa3DOB/lWVrrk6K/BX6Et5QldEDN3CawKwBG","zeonglobal","zeonglobal","","2009-08-07","female","Christianity","","","","","","","","","PARENT","","","","0","0","0","0","","0","","check_result","activated","2021-12-15 22:58:46"),
("29","29189df4bda51","189","15","3","0","0","0","0","","ABDUL-HAFEEZ","MAHMOOD","DAWUD","S/21/0029","$2y$10$KHyYsLE//Ogu8eKIs8qdUOxQV3oZQFiWioME//bdP/0OHH2QV7Fwe","zeonglobal","zeonglobal","","2009-08-11","male","Islam","","","","","","","","","PARENT","","","","0","0","0","0","","0","","check_result","activated","2021-12-15 23:03:40"),
("30","30189acad8a7a","189","16","3","0","0","0","0","","WEST-PRIZELYN","IFEOMA","DIKE","S/21/0030","$2y$10$DYnfxY/mR7K2DeaRNluKXemjoqD2UBe8kvoPWjJlffV/k2z1UXS7K","zeonglobal","zeonglobal","","2006-11-23","female","Christianity","","","","","","","","","PARENT","","","","0","0","0","0","","0","","check_result","activated","2021-12-15 23:10:14"),
("31","31189e02d6c14","189","17","3","0","0","0","0","","PRINCE","UDOKA","NWOKORO","S/21/0031","$2y$10$E6tQdZ2Lak/Kdzt6YoD7jeHjJVhElRWCpbJ0wKrFDZ52Mz6ZT9f76","zeonglobal","zeonglobal","","2008-10-18","male","Christianity","","","","","","","","","PARENT","","","","0","0","0","0","","0","","check_result","activated","2021-12-15 23:17:11"),
("32","321897a53a465","189","18","3","0","0","0","0","","PAUL","AJI","OKPE-AJI","S/21/0032","$2y$10$vWuFq7gVAnQMLeT9FvJuruie7KLsuNPDkyhx0FAU8WLXvqBGXQ7be","zeonglobal","zeonglobal","","2021-12-15","male","Christianity","","","","","","","","","PARENT","","","","0","0","0","0","","0","","check_result","activated","2021-12-15 23:20:08"),
("33","33189b9974d45","189","19","3","0","0","0","0","","DARIAN","OJONEDU","MICHAEL UWADA","S/21/0033","$2y$10$DnKpuUasFLc6px.dlE8s/uO/m07WoCJku8OkFGFF9LLip3O0Mq0TG","zeonglobal","zeonglobal","","2011-09-25","male","Christianity","","","","","","","","","PARENT","","","","0","0","0","0","","0","","check_result","activated","2021-12-15 23:27:18"),
("34","341893d55ab2d","189","18","2","0","0","0","0","","JACOB","","OKPE-AJI","S/21/0034","$2y$10$R7Pgw5Fwzhsm9Oi1/jrm..8y9mO9/MDwzxzMcJC4l.FhOQqPfg8zK","jijacob","jijacob","","2021-12-02","male","Christianity","","","","","","","","","","","new_student","","0","0","0","0","","0","","check_result","activated","2021-12-17 10:26:14"),
("35","3518963373bd1","189","42","1","0","0","0","0","","PRAISE","","ABIAZIEM","S/21/0035","$2y$10$ItJdLjdDc/qglLp7dLGL5urS/u6K/09qJkpCrBmdMYoUg3LT21WAi","zeonglobal","zeonglobal","noemail@gmail.com","2012-04-06","female","Christianity","","","","","","","","","PARENT","","new_student","","0","0","0","0","","0","","check_result","activated","2022-02-21 11:33:28");




CREATE TABLE `subclass` (
  `subclass_id` int(11) NOT NULL AUTO_INCREMENT,
  `subclass_name` varchar(30) NOT NULL,
  PRIMARY KEY (`subclass_id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=latin1;


INSERT INTO subclass VALUES
("1","A"),
("2","B");




CREATE TABLE `subject_class` (
  `subject_class_id` int(11) NOT NULL AUTO_INCREMENT,
  `subject_id` int(11) NOT NULL,
  `class_id` int(11) NOT NULL,
  PRIMARY KEY (`subject_class_id`)
) ENGINE=InnoDB AUTO_INCREMENT=71 DEFAULT CHARSET=latin1;


INSERT INTO subject_class VALUES
("3","1","4"),
("5","1","5"),
("6","1","6"),
("8","5","3"),
("9","6","3"),
("10","8","3"),
("11","9","3"),
("12","10","3"),
("13","11","3"),
("14","12","3"),
("15","13","3"),
("22","10","1"),
("23","11","1"),
("24","12","1"),
("25","13","1"),
("26","5","1"),
("27","6","1"),
("28","7","1"),
("29","8","1"),
("30","9","1"),
("32","16","2"),
("34","5","2"),
("35","6","2"),
("36","8","2"),
("37","9","2"),
("38","17","2"),
("39","1","2"),
("40","10","2"),
("41","11","2"),
("42","12","2"),
("43","13","2"),
("44","14","2"),
("45","15","2"),
("46","2","2"),
("47","3","2"),
("48","7","2"),
("49","18","2"),
("50","1","3"),
("51","18","3"),
("52","2","3"),
("53","3","3"),
("54","1","1"),
("55","18","1"),
("56","2","1"),
("57","3","1"),
("58","17","1"),
("59","14","1"),
("60","16","1"),
("61","14","3"),
("62","16","3"),
("63","17","3"),
("64","7","3"),
("66","15","1"),
("67","15","3"),
("68","4","1"),
("69","4","2"),
("70","4","3");




CREATE TABLE `subjects` (
  `subject_id` int(11) NOT NULL AUTO_INCREMENT,
  `subject_name` varchar(50) NOT NULL,
  `subject_short` varchar(30) NOT NULL,
  `groups` varchar(100) NOT NULL,
  PRIMARY KEY (`subject_id`),
  KEY `groups` (`groups`)
) ENGINE=InnoDB AUTO_INCREMENT=19 DEFAULT CHARSET=latin1;


INSERT INTO subjects VALUES
("1","ENGLISH LANGUAGE","ENG","both"),
("2","CULTURAL AND CREATIVE ARTS","C.C.A","both"),
("3","LITERATURE-IN-ENGLISH","LIT","both"),
("4","BASIC TECHNOLOGY","BASIC TECH","both"),
("5","BASIC SCIENCE","BASIC SCI","both"),
("6","HOME ECONOMICS","HOMEC","both"),
("7","ISLAMIC RELIGIOUS STUDIES","IRS","both"),
("8","AGRICULTURAL SCIENCE","AGRIC SCI","both"),
("9","MATHEMATICS","MATHS","both"),
("10","CIVIC EDUCATION","CIVIC","both"),
("11","SECURITY EDUCATION","SEC EDU","both"),
("12","SOCIAL STUDIES","SOCIAL ST","both"),
("13","CHRISTIAN RELIGIOUS STUDIES","CRS","both"),
("14","BUSINESS STUDIES","BUS STU","both"),
("15","FRENCH LANGUAGE","FRENCH","both"),
("16","HAUSA","HAUSA","junior"),
("17","PHYSICAL AND HEALTH EDUCATION","P.H.E","junior"),
("18","INFORMATION & COMMUNICATION TECHNOLOGY","ICT","both");




CREATE TABLE `test` (
  `test_id` int(11) NOT NULL AUTO_INCREMENT,
  `test_page_id` int(11) NOT NULL,
  `student_id` int(11) NOT NULL,
  `class_id` int(11) NOT NULL,
  `subclass_id` int(11) NOT NULL,
  `subject_id` int(11) NOT NULL,
  `class_name` varchar(50) NOT NULL,
  `subclass_name` varchar(50) NOT NULL,
  `subject_name` varchar(100) NOT NULL,
  `student_score` float DEFAULT NULL,
  `status` varchar(10) NOT NULL,
  `sessions` char(20) NOT NULL,
  `terms` char(20) NOT NULL,
  PRIMARY KEY (`test_id`),
  KEY `test_page_id` (`test_page_id`),
  KEY `class_id` (`class_id`),
  KEY `subclass_id` (`subclass_id`),
  KEY `subject_id` (`subject_id`),
  KEY `student_score` (`student_score`),
  KEY `status` (`status`),
  KEY `sessions` (`sessions`),
  KEY `terms` (`terms`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;






CREATE TABLE `test_page` (
  `test_page_id` int(11) NOT NULL AUTO_INCREMENT,
  `subject_id` int(11) NOT NULL,
  `class_id` int(11) NOT NULL,
  `subclass_id` int(11) NOT NULL,
  `class_name` varchar(50) NOT NULL,
  `subclass_name` varchar(50) NOT NULL,
  `subject_name` varchar(100) NOT NULL,
  `test_title` varchar(100) NOT NULL,
  `total_score` float NOT NULL,
  `students` int(11) NOT NULL,
  `status` varchar(10) NOT NULL,
  `sessions` char(20) NOT NULL,
  `terms` char(20) NOT NULL,
  `date_added` datetime NOT NULL,
  PRIMARY KEY (`test_page_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;






CREATE TABLE `topic` (
  `topic_id` int(11) NOT NULL AUTO_INCREMENT,
  `topic_name` varchar(200) NOT NULL,
  `class_id` int(11) NOT NULL,
  `subclass_id` int(11) NOT NULL,
  `subject_id` int(11) NOT NULL,
  `user_id` int(11) NOT NULL,
  `table_name` varchar(20) NOT NULL,
  `published` varchar(20) NOT NULL DEFAULT 'not_published',
  `discussion_signal` tinyint(4) NOT NULL,
  `sessions` varchar(15) NOT NULL,
  `terms` varchar(15) NOT NULL,
  `date_added` datetime NOT NULL DEFAULT current_timestamp(),
  PRIMARY KEY (`topic_id`),
  KEY `class_id` (`class_id`),
  KEY `subclass_id` (`subclass_id`),
  KEY `subject_id` (`subject_id`),
  KEY `user_id` (`user_id`),
  KEY `published` (`published`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;






CREATE TABLE `topic_discussions` (
  `topic_discussions_id` int(11) NOT NULL AUTO_INCREMENT,
  `topic_id` int(11) NOT NULL,
  `user_id` int(11) NOT NULL,
  `table_name` varchar(20) NOT NULL,
  `discussion` varchar(300) NOT NULL,
  `date_added` datetime NOT NULL DEFAULT current_timestamp(),
  PRIMARY KEY (`topic_discussions_id`),
  KEY `user_id` (`user_id`),
  KEY `topic_id` (`topic_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;






CREATE TABLE `transfer_current_fees_info` (
  `current_fees_info_id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `student_id` int(11) unsigned NOT NULL,
  `class_id` int(10) unsigned NOT NULL,
  `current_school_fees` decimal(15,2) NOT NULL,
  `past_debt` decimal(15,2) NOT NULL,
  `amount_to_pay` decimal(15,2) NOT NULL,
  `amount_paid` decimal(15,2) NOT NULL,
  `discount` decimal(15,2) NOT NULL,
  `surcharge_amount` decimal(15,2) NOT NULL,
  `surcharge_reason` varchar(500) NOT NULL,
  `wave_over` decimal(15,2) NOT NULL,
  `owing` decimal(15,2) NOT NULL,
  `present_owing` decimal(15,2) NOT NULL,
  `class_fee` decimal(15,2) NOT NULL,
  `plan_fee` decimal(15,2) NOT NULL,
  `new_student_fee` decimal(15,2) NOT NULL,
  `room_fee` decimal(15,2) NOT NULL,
  `sessions` varchar(20) NOT NULL,
  `terms` varchar(20) NOT NULL,
  PRIMARY KEY (`current_fees_info_id`),
  KEY `student_id` (`student_id`),
  KEY `sess_term` (`sessions`,`terms`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;






CREATE TABLE `transfer_fees_discount` (
  `fees_discount_id` int(11) NOT NULL AUTO_INCREMENT,
  `student_id` int(11) NOT NULL,
  `amount` decimal(15,2) NOT NULL,
  `reason` varchar(300) NOT NULL,
  `sessions` varchar(20) NOT NULL,
  `terms` varchar(20) NOT NULL,
  PRIMARY KEY (`fees_discount_id`),
  KEY `student_id` (`student_id`),
  KEY `session_term` (`sessions`,`terms`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;






CREATE TABLE `transfer_result_main` (
  `result_main_id` int(11) NOT NULL AUTO_INCREMENT,
  `student_id` int(11) NOT NULL,
  `class_id` int(11) NOT NULL,
  `class_name` char(50) NOT NULL,
  `section` varchar(10) NOT NULL,
  `subclass_id` int(11) NOT NULL,
  `subclass_name` char(50) NOT NULL,
  `total` float NOT NULL,
  `cumulative_total` float NOT NULL,
  `total_obtainable` float NOT NULL,
  `cumu_total_obtainable` float NOT NULL,
  `average` varchar(10) NOT NULL,
  `cumulative_average` varchar(10) NOT NULL,
  `position_class` varchar(20) NOT NULL,
  `cumulative_position_class` varchar(20) NOT NULL,
  `position_subclass` varchar(20) NOT NULL,
  `cumulative_position_subclass` varchar(20) NOT NULL,
  `student_attendance` int(11) DEFAULT NULL,
  `total_attendance` int(11) DEFAULT NULL,
  `total_student_class` int(10) unsigned NOT NULL,
  `total_student_subclass` int(10) unsigned NOT NULL,
  `cumulative_total_student_class` int(10) unsigned NOT NULL,
  `cumulative_total_student_subclass` int(10) unsigned NOT NULL,
  `handwriting` int(11) NOT NULL,
  `cumulative_handwriting` int(11) NOT NULL,
  `neatness` int(11) NOT NULL,
  `cumulative_neatness` int(11) NOT NULL,
  `punctuality` int(11) NOT NULL,
  `cumulative_punctuality` int(11) NOT NULL,
  `attentiveness` int(11) NOT NULL,
  `cumulative_attentiveness` int(11) NOT NULL,
  `initiative` int(11) NOT NULL,
  `cumulative_initiative` int(11) NOT NULL,
  `respect` int(11) NOT NULL,
  `cumulative_respect` int(11) NOT NULL,
  `obedience` int(11) NOT NULL,
  `cumulative_obedience` int(11) NOT NULL,
  `attitude` int(11) NOT NULL,
  `cumulative_attitude` int(11) NOT NULL,
  `honesty` int(11) NOT NULL,
  `cumulative_honesty` int(11) NOT NULL,
  `creativity` int(11) NOT NULL,
  `cumulative_creativity` int(11) NOT NULL,
  `behaviour1_name` varchar(100) NOT NULL,
  `behaviour2_name` varchar(100) NOT NULL,
  `behaviour3_name` varchar(100) NOT NULL,
  `behaviour4_name` varchar(100) NOT NULL,
  `behaviour5_name` varchar(100) NOT NULL,
  `behaviour6_name` varchar(100) NOT NULL,
  `behaviour7_name` varchar(100) NOT NULL,
  `behaviour8_name` varchar(100) NOT NULL,
  `behaviour9_name` varchar(100) NOT NULL,
  `behaviour10_name` varchar(100) NOT NULL,
  `promotion` varchar(50) NOT NULL,
  `promotion_class_id` int(11) NOT NULL,
  `promotion_class_name` varchar(50) NOT NULL,
  `promotion_comment` varchar(500) NOT NULL,
  `promotion_subclass_id` int(11) NOT NULL,
  `promotion_subclass_name` varchar(50) NOT NULL,
  `pass_ave` varchar(5) NOT NULL,
  `scratch_card_number` varchar(16) NOT NULL,
  `next_term_begins` date NOT NULL,
  `ca1_total_score` float NOT NULL,
  `ca2_total_score` float NOT NULL,
  `ca3_total_score` float NOT NULL,
  `ca4_total_score` float NOT NULL,
  `ca5_total_score` float NOT NULL,
  `ca6_total_score` float NOT NULL,
  `ca_total_score` float NOT NULL,
  `exam_total_score` float NOT NULL,
  `no_of_ca` int(11) NOT NULL,
  `exam_name` varchar(50) NOT NULL,
  `ca_name_1` varchar(50) NOT NULL,
  `ca_name_2` varchar(50) NOT NULL,
  `ca_name_3` varchar(50) NOT NULL,
  `ca_name_4` varchar(50) NOT NULL,
  `ca_name_5` varchar(50) NOT NULL,
  `ca_name_6` varchar(50) NOT NULL,
  `principal_name` varchar(100) NOT NULL,
  `principal_comment` text NOT NULL,
  `form_staff_name` varchar(200) NOT NULL,
  `form_staff_comment` text NOT NULL,
  `student_affairs_comment` text NOT NULL,
  `cumulative_principal_comment` text NOT NULL,
  `cumulative_form_staff_comment` text NOT NULL,
  `principal_signature` varchar(150) NOT NULL,
  `second_principal_signature` varchar(60) NOT NULL,
  `visited` int(11) NOT NULL,
  `sessions` varchar(20) NOT NULL,
  `terms` varchar(20) NOT NULL,
  PRIMARY KEY (`result_main_id`),
  KEY `student_id` (`student_id`),
  KEY `sessions` (`sessions`),
  KEY `terms` (`terms`),
  KEY `promotion` (`promotion`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;






CREATE TABLE `transfer_result_subject` (
  `result_subject_id` int(11) NOT NULL AUTO_INCREMENT,
  `student_id` int(11) NOT NULL,
  `class_id` int(11) NOT NULL,
  `subclass_id` int(11) NOT NULL,
  `class_name` varchar(50) NOT NULL,
  `subclass_name` varchar(50) NOT NULL,
  `subject_name` varchar(100) NOT NULL,
  `subject_id` int(11) NOT NULL,
  `ca1` float DEFAULT NULL,
  `ca2` float DEFAULT NULL,
  `ca3` float DEFAULT NULL,
  `ca4` float DEFAULT NULL,
  `ca5` float DEFAULT NULL,
  `ca6` float DEFAULT NULL,
  `ca` float DEFAULT NULL,
  `exam` float DEFAULT NULL,
  `sum_total` float DEFAULT NULL,
  `total` float NOT NULL,
  `cumulative_score` float NOT NULL,
  `cumulative_score_percent` float DEFAULT NULL,
  `cumulative_position` char(10) NOT NULL,
  `position_subclass` varchar(20) NOT NULL,
  `grade` varchar(5) NOT NULL,
  `grade_comment` varchar(50) NOT NULL,
  `staff_name` varchar(200) NOT NULL,
  `staff_comment` varchar(60) NOT NULL,
  `attendance` int(11) DEFAULT NULL,
  `percent_attendance` varchar(10) DEFAULT NULL,
  `handwriting` int(11) NOT NULL,
  `neatness` int(11) NOT NULL,
  `punctuality` int(11) NOT NULL,
  `attentiveness` int(11) NOT NULL,
  `initiative` int(11) NOT NULL,
  `respect` int(11) NOT NULL,
  `obedience` int(11) NOT NULL,
  `attitude` int(11) NOT NULL,
  `honesty` int(11) NOT NULL,
  `creativity` int(11) NOT NULL,
  `status` varchar(10) NOT NULL,
  `sessions` varchar(20) NOT NULL,
  `terms` varchar(10) NOT NULL,
  PRIMARY KEY (`result_subject_id`),
  KEY `sess_term` (`sessions`,`terms`),
  KEY `foreign_keys` (`student_id`,`class_id`,`subclass_id`,`subject_id`),
  KEY `status` (`status`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;






CREATE TABLE `transfer_salary_info` (
  `salary_info_id` int(11) NOT NULL AUTO_INCREMENT,
  `staff_id` int(11) NOT NULL,
  `current_salary` decimal(15,2) NOT NULL,
  `past_debt` decimal(15,2) NOT NULL,
  `amount_to_pay` decimal(15,2) NOT NULL,
  `amount_paid` decimal(15,2) NOT NULL,
  `wave_over` decimal(15,2) NOT NULL,
  `current_debt` decimal(15,2) NOT NULL,
  `deduct` decimal(15,2) NOT NULL,
  `appreciation_amount` decimal(15,2) NOT NULL,
  `appreciation_reason` varchar(500) NOT NULL,
  `owing` decimal(15,2) NOT NULL,
  `sessions` varchar(20) NOT NULL,
  `terms` varchar(20) NOT NULL,
  `months` varchar(30) NOT NULL,
  PRIMARY KEY (`salary_info_id`),
  KEY `staff_id` (`staff_id`),
  KEY `sessions` (`sessions`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;






CREATE TABLE `transfer_salary_payment` (
  `salary_payment_id` int(11) NOT NULL AUTO_INCREMENT,
  `staff_id` int(11) NOT NULL,
  `accountant_id` int(10) unsigned NOT NULL,
  `amount_paid` decimal(15,2) NOT NULL,
  `staff_name` varchar(200) NOT NULL,
  `sessions` varchar(20) NOT NULL,
  `terms` varchar(20) NOT NULL,
  `months` varchar(30) NOT NULL,
  `date_added` datetime NOT NULL,
  PRIMARY KEY (`salary_payment_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;






CREATE TABLE `transfer_school_fees` (
  `school_fees_id` int(11) NOT NULL AUTO_INCREMENT,
  `transaction_id` char(20) NOT NULL,
  `student_id` int(11) NOT NULL,
  `staff_id` int(11) NOT NULL,
  `plan_id` int(11) NOT NULL,
  `school_fees_payment_mode_id` int(11) NOT NULL,
  `payment_mode` varchar(300) NOT NULL,
  `staff_name` varchar(200) NOT NULL,
  `amount_paid` decimal(15,2) NOT NULL,
  `payment_no` varchar(20) NOT NULL,
  `fees_status` varchar(20) NOT NULL,
  `sessions` varchar(20) NOT NULL,
  `terms` varchar(10) NOT NULL,
  `date_added` datetime NOT NULL,
  PRIMARY KEY (`school_fees_id`),
  KEY `sessions` (`sessions`),
  KEY `terms` (`terms`),
  KEY `transaction_id` (`transaction_id`),
  KEY `school_fees_payment_mode_id` (`school_fees_payment_mode_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;






CREATE TABLE `transferred_students` (
  `transferred_student_id` int(11) NOT NULL AUTO_INCREMENT,
  `student_id` int(11) NOT NULL,
  `parent_id` int(11) NOT NULL,
  `student_name` varchar(300) NOT NULL,
  `class_id` int(11) NOT NULL,
  `old_class_name` varchar(100) NOT NULL,
  `new_class_name` varchar(100) NOT NULL,
  `serial_number` varchar(50) NOT NULL,
  `school_id` int(11) NOT NULL,
  `database_name` varchar(100) NOT NULL,
  `status` varchar(30) NOT NULL,
  `date_transferred` datetime NOT NULL,
  PRIMARY KEY (`transferred_student_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;






CREATE TABLE `zoom` (
  `zoom_id` int(11) NOT NULL AUTO_INCREMENT,
  `class_id` int(11) NOT NULL,
  `class_category_id` int(11) NOT NULL,
  `email` varchar(100) NOT NULL,
  `pass` varchar(50) NOT NULL,
  `api_key` varchar(200) NOT NULL,
  `api_secret` varchar(200) NOT NULL,
  `meeting_id` varchar(20) NOT NULL,
  `meeting_password` varchar(30) NOT NULL,
  `meeting_url_pwd` varchar(400) NOT NULL,
  `host_key` varchar(20) NOT NULL,
  `date_added` datetime NOT NULL DEFAULT current_timestamp(),
  PRIMARY KEY (`zoom_id`),
  KEY `class_id` (`class_id`),
  KEY `class_category_id` (`class_category_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;






