-- Standard Nigerian secondary school grading scale. Adjust per-school
-- if a client uses a different band (this is the most common default).

INSERT IGNORE INTO grading_systems (grade, min_score, max_score, remark) VALUES
('A', 75.00, 100.00, 'Excellent'),
('B', 65.00, 74.99, 'Very Good'),
('C', 55.00, 64.99, 'Good'),
('D', 45.00, 54.99, 'Pass'),
('E', 40.00, 44.99, 'Fair'),
('F', 0.00, 39.99, 'Fail');
